[thelist] RE: Long Date to Datetime Conversion

Dan CRACIUN dcsquare at myrealbox.com
Fri Dec 6 10:40:01 CST 2002

Hi Alan,

You might wanna try:

$sql="UPDATE mystories SET time=/"$date/" WHERE
Without a WHERE clause the UPDATE updates ALL the rows in the table.

Dan Craciun

# Update each record with new date format
$sql = "UPDATE mystories SET time='$date'";

# Not too sure about this line...
$newresult = mysql_query($sql);

More information about the thelist mailing list