formatting date from mysql with php

[__greg]

i have a timestamp in a mysql database and i was wondering how i can format the display of that using PHP, not a mysql query.

I need to format it using php because otherwise, the sorting will get messed up with the year.

if anyone can help i'd really appreciate it. thanks

[csousley]

$timestamp = date('U'); // or pulled from DB, whatever //
echo date('M jS, Y', $timestamp);
// or //
echo date('r', $timestamp);

or about a million other combos, you can format it however you would like.

Hope this helps.