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
