| |
| |
| |
|
Page: 1 2
Comments:
<0> hi
<1> hi
<0> maybe somewhere here can help me with a small problem I have
<2> not unless my mind reading skills pick up
<1> hehe, most coders have poor reading skills,
<0> right well I have a php script that sends 3 things to the mysql DB
<1> look at any online tutorial
<2> reading and writing's all good and well for me.... it's speaking that troubles me
<2> I can naver be sure that I've actualy been speaking english - I get so many blank looks
<0> one is the username the other is either yes or no and the third is where the problem is I use NOW in php to send the time but I dont know why the time is always wrong
<1> well, you are typing now
<2> http://www.php.net/mysql_connect http://www.php.net/mysql_select_db http://www.php.net/mysql_query
<2> typing is fine, speaking is not (c:
<0> yeah its different speaking English to typing it
<2> try now() in mysql not php
<2> remmember, the time stored will be the time on the server, not the time where you are
<0> yeah well the time i had was with a date in 1969 lol
<0> I was thinking maybe I have something weong in mysql
<0> wrong*
<1> i created a table in mysql, now i am ready for a few beers
<2> use the now() function in mysql not in php
<0> my DB has 57 tables and im kinda a mysql n00b
<2> they return different functions
<2> I've got something like 20 odd db's with table counts from 8 > 300 tables... I'm still a noob
<2> I'm always learning new things to make it easier (c:
<0> im a php n00b too lol
<2> 70k lines of php later, I'm still picking up php stuff... I'm in the process of moving to php5... lots of new **** there
<0> I have nearly 12,000 lines with this site at the moment
<0> i have maybe another 8-10k more then im done :)
<2> proprietry administration system... every time I sign off on it they want more done
<0> lol
<0> I dont think mine ever will be either
<2> I want to start it over again (will be the third time) every time I build the system they need, they change the way they do things or change what they need and I have to patch the crap out of it
<0> lol
<2> first time it did what they told me it needed it to do..
<0> I will probably get some freelancer to finish my project
<2> this time I built it to emulate what I saw they needed... then bang... government gets involved and it needs to be totaly different
<0> how long have you been coding php?
<2> a while... 3 years? 4 maybe...
<2> before that it was perl
<2> and before that it was pascal
<0> cool
<3> Perl forever
<2> I still do almost all my console and backend in perl - but I php all the web stuff
<0> im coding a blackjack game, slot machine game, keno and a race track but its beyond me :p
<2> I have to work with a chap who insists on coding everything in python
<0> Freman where are you from?
<2> Australia
<2> where it's bed time about now (c:
<0> lol
<2> 11:35 pm... still bloody 30 deg C
<4> ouch
<4> 7 or so here, quite hot really
<4> average the past days is sub-zero
<2> I'll swap!
<4> hehe
<5> 3.1 C this morning
<4> HDD crashed awfully earlier
<4> lost 100 GB of data
<5> :O
<5> you have backups right?
<4> yes and no
<4> I have backups of what I want backups of, and can get the rest from remote locations
<4> but I need to fix up the partition tables
<4> too many > 100 GB files
<4> filesystem didn't like it, so I'm avoiding it from now on :)
<5> 100 GB = database file?
<4> encrypted container
<5> ah
<4> so I'm skipping the container part, and encrypt the original filesystem instead
<5> cool
<4> only reason I didn't do so in the first place was lack of space to do it
<4> so had to create,move,grow,move,grow,move ..
<5> heh
<4> hehe
<5> i was too chicken to try it ;D
<5> i'm going to install mandriva on my hp kayak. it's 600 vs the 500 dell my wife is currantly using
<5> trying to speed things up for her
<4> how are you liking it so far?
<5> so far so good. i haven't realy used it much myself but my wife hasn't complained
<5> it's just a little slow
<4> hmm, how much RAM?
<5> switched her to fluxbox and that helped
<4> yeah
<5> 128
<5> same on the kayak
<5> but i found some chips i'm going to try
<4> been too long since I had a system with 128 MB of RAM
<4> 5+ years at least
<5> heh
<5> that's hold old that box is
<4> had 198 on my pentium 133
<6> skryt
<6> *erhm*
<4> [root@cm-80 mnt]# losetup -e blowfish-256 /dev/loop20 /dev/sdb2
<4> P***word:
<4> [root@cm-80 mnt]# mke2fs -j /dev/loop20
<4> almost recovered
<5> cool
<2> e17 rox
<4> /dev/sdb2 117G 33M 117G 1% /mnt/sdb2
<4> ... again
<5> heh
<4> at least it let me allow to copy files to it, that is better than before
<4> hmm, maybe I should do the same for sda as well
<7> How i can see the databases list ?
<7> what is the command ?
<5> show
<7> thanks
<5> http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
<5> your welcome
<8> hi, do i need to format a date in php to add to mysql or does mysql do it buy itself
<8> by itself
<4> http://www.kfwebs.net/links/6 for SQL
<4> you don't really make any sense..
<8> well..
<8> when i add restaurant to my database i format a date to add as data to the database, but do i need to do that, becasue mysql has a date fieldtype, im thinking maybe it will add a date by itself for an added restaurant
<4> ?
<4> you don't make any sense at all
<4> nor can you have any clue what you're doing
<8> i think i do because its working now
<4> read up on default values, read up on date and time functions, read up on DATE type, read about anything
<4> the hell you do
<8> but suddenly im thinking maybe im doing something thats not necessary
<8> thank you for the help mr "never had to learn about mysql"
<4> ?
<5> heh, was that mr "never read the freaking manual" ?
<4> probably, yes
<5> also known as mr "let someone else read it for you"
<4> lol
<4> <-- X has kicked yourob from #sql ((jackfig) they were p***ing out BRAINS, not TRAINS, when you let them p*** you by)
<5> heh
<5> one of these days i'm going to pipe an entire manual through /msg to someone
<5> cool
<9> why do i get a syntax error for: CREATE TABLE tb_order2 (c1 CHAR(10)) DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci ?
<4> SELECT version();
<9> 4.1
<10> Im having a problem getting my script to build my schema. When I introduce foreign keys to a table it doesn't work. Here's the syntax: foreign key (school_id) references table schools (school_id)
<10> any reason why this doesn't work? Thanks.
<4> adiv: and the error you get is?
<4> for one thing you lack a PK
<9> a syntax error
Return to
#mysql
or
Go to some related
logs:
#AllNiteCafe
Execute database.sql script on MySQL server to create necessary tables
#linux
#AllNiteCafe
muiedinamo
figureof speech
sixy faking
#chatzone
#linux
#skype
|
|