Date Formatting

[Anon]

I have a date stored in a mysql table. I am retrieving that date along with other data from that table using the mysql_fetch_array as shown below:

$result = mysql_query($sql);
$row = mysql_fetch_array($result);

while ($row = mysql_fetch_array($result)){

print("$row[field1], $row[field2], $row[ShowDate]), $row[field4]");

}

I tried formating the date with sql using DATE_FORMAT(ShowDate,"%c/%e/%Y") and this did not work within my script. I have also tried using php's date("m/j/Y", $row[ShowDate]) but I think my syntax is incorrect.

Can anyone suggest what I'm doing wrong?

thnx

[losang]

Eben,

The date is probably something like 2001-03-29 when it is stored in the database.  If this is so I am not sure what your problem is.  I would try using some string functions to parse the date string returned from the database into pieces and reformat as you like.  I would search php.net for the function 'time()' or something like that.  php.net has online docs on all of php's functions.

Best of luck,

losang