> <?php
> $query="insert into table_name (group_id, session_date) values (1, " .
> date("m-d-Y", time()) . ")";
> $result=mysq_query($query);
> ?>
the reason this didn't work is because your php date function requires a format
string but you put it in doublequotes which in this situation terminated the
$query string
the best way around this, in my humble opinion, is not to use the scripting
language for this purpose
rather, let the database use its own version of the current date
insert into table_name
(group_id, session_date)
values (1, current_date)
here current_date is the standard sql function
rudy
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
