php date function

Osai22

Hello, please can anyone help me with a syntax on how to format a date from mysql table with php? the date in mysql table is like this 2011-03-05 and I want to format is like this Saturday March 05, 2011. I want each time i echo out any date from the table the date will be in this format (Saturday March 05, 2011).

Waiting for a quick response.

Thank you

bradgrafelman

MySQL has its own DATE_FORMAT() function you can use to SELECT the date in whatever format you desire.

Osai22

I am just new on all these coding stuff, can you help me with a syntax?

ddhh2002

$your_date = strtotime($your_date);

$your_date = date('l F d, Y', $your_date);

echo $your_date;

Osai22

Thank you for the syntax, how do I use the date format result to query the database date field?

bradgrafelman

Did you read the MySQL manual page I linked you to? Not only does it explain how to use the function, but it also gives several example queries.

Try it yourself and post what you tried if you can't get it to work.