PHP Date and mysql

wxdqz

New Member
Hi, i have a database of around 1000 stock prices at a certain date and i
want to display them all in a table.

The problem is, the dates displayed in column 1 of the table is in the form
YYYY-MM-DD
I want to change the form to MM DD, YYYY.

This following script displays the dates correctly, but not in the format i
want.

{
printf("<tr><td>%s</td><td>%s/</td><td>%s</td></tr>\n",
$myrow["Date"]), $myrow["Point"], $myrow["Low"]);
}


I tried changing it to the following, but now, instead of giving me a list
of dates(which go from earliest to present), it gives me the exactly SAME
date over and over again.

what's wrong withj this script?
{
printf("<tr><td>%s</td><td>%s/</td><td>%s</td></tr>\n",
date('M D Y',$myrow["Date"]), $myrow["Point"], $myrow["Low"]);
}

anyone know why??

Thanx in advance
 
Back
Top