formating date from returned mysql query
Posted: Thu Jul 13, 2006 3:14 pm
Weirdan | Please use
can anyone help please?
Weirdan | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
i have a table in mysql setup with information about upcoming shows for a band
the date column has the date formatted as yyyy-mm-dd
when i display the date on the webpage from the mysql query i want it to be displayed as mm-dd-yyyy
here's the code i use (took out all the other column info)Code: Select all
$display = mysql_query("SELECT * FROM SHOWS");
while ($row=mysql_fetch_array($display) ){
echo($row["DATE"]);
}Weirdan | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]