[thelist] RE: Long Date to Datetime Conversion

[Dan CRACIUN]

Hi Alan,

You might wanna try:

$sql="UPDATE mystories SET time=/"$date/" WHERE
oldformatColumnName=/"$myrow[17]/");
Without a WHERE clause the UPDATE updates ALL the rows in the table.

Cheers,
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);