> 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.
more specifically, you need to surround them with singlequotes
in every database except microsoft access, which uses octothorps instead
one more pecadillo: mysql insists on a year-month-day sequence for input dates
so even if you wanted to use the php function date("m-d-Y", time())
you would have to change that format
another mysql feature: the singlequotes are optional as long as there aren't
any characters like the dash or slash in the date value
so you can say '2004-06-02' or 20040602 (or several other variations)
however, using the mysql current_date function is more efficient
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.
