thanks... but that's not it john... i'm not worried about creating the sql_statement in the php... i'm concerned that i can't seem to craft/create a basic sql cmd within mysql to get a value (other than NOW()) to work... if i do (from mysql) -->> insert into foo (id, time) values (2, 333333), it doesn't work... if i -->> insert into foo (id, time) values (2, NOW()), it works!!... my question is why??? -bruce -----Original Message----- From: John Nichel [mailto:john@xxxxxxxxxxxx] Sent: Monday, September 26, 2005 11:00 AM To: php-general@xxxxxxxxxxxxx Subject: Re: mysql/php date functions.. bruce wrote: > how can i create a mysql sql statement to insert a php 'time()' into mysql? > > i've got the mysql var 't1, timestamp' but i can't figure out how to do an > insert > > $q = time(); > $sql = sprintf("insert into foo (id, ctime) values(%d, %???), $id, $q); > > can't figure out how to get this to work... > > if i create a sql statement and run it directly within mysql, > > -->insert into foo (id, ctime) values(2, NOW()); > > this works.. but i can't figure out how to create the sql using the php > time() function and getting the insert from the php app... > > so what's the basic part i'm missing??!! > > -bruce $sql = "INSERT INTO db.table ( id, ctime ) VALUES ( " . $id . ", " . time() . " )"; -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 john@xxxxxxxxxxxx -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
