[wdvltalk] Re: MySQL/PHP date

[Howard Cheng]

Agreed with Rudy in that it's always best to have a single authority for 
timestamps, which is usually the database server. However, if you must 
use your scripting language to add dates, then you need to surround them 
with quotes for MySQL, like a string value.

rudy wrote:
<?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
--
::::::::::::::::::::::::::::::
Howard Cheng
http://www.howcheng.com/
Wise-cracking quote goes here.
____ � 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.