date issues with php and mysql

[Phip]

$sql = mysql_query("SELECT DATE_FORMAT(date_column, ' %b %d %Y ') FROM table ORDER BY id") or die(mysql_error());

how do i make that work?

i'm assuming you take, say, 2002-04-17 out of mysql and have php process it into
apr-17-2002. i thought this would be how you do it. but it doesn't seem to want to work.

[Jeewhizz]

how do you mena it doesn't work? Try searching the forum for formattimg MySQL dates, i've written a lengthy post on it before :)

Jee