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
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