[thelist] RE: Long Date to Datetime Conversion

[Alan McCoy]

That did it. Thanks!

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);
::
:: --
:: * * Please support the community that supports you.  * *
:: http://evolt.org/help_support_evolt/
::
:: For unsubscribe and
:: other options, including the Tip Harvester
:: and archives of thelist go to: http://lists.evolt.org
:: Workers of the Web, evolt !
::