On Sat, 2003-11-08 at 15:21, Christian Ista wrote: > <?php echo mysql_result($result_cat,0,"CATC_DATE");?> > > a string like that : 2003-11-07 and I'd like display 07/11/2003
I usually do:
<?
$query = "SELECT UNIX_TIMESTAMP(datefield) as unixtime FROM table";
$timestamp = mysql_result($result, "unixtime");
$date = date("d/m/Y", $timestamp);
echo $date;
?>
Regards,
Filip de Waard
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
