|
|
Posted by "bruce" on 09/26/05 21:13
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@kegworks.com]
Sent: Monday, September 26, 2005 11:00 AM
To: php-general@lists.php.net
Subject: Re: [PHP] 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@kegworks.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Navigation:
[Reply to this message]
|