Change your query:
select dayofmonth(Posted) as DOM_Posted,
month(Posted) as M_Posted,
year(Posted)as Y_Posted,
hour(Posted) as HH_Posted,
minute(Posted) as MM_Posted,
Name,
Prayer
from prayer
Then access the access the fields by the name (DOM_Posted).
$recSet = mysql_query($query);
$row = mysql_fetch_assoc($recSet);
Access individual field:
$row['DOM_Posted'];
$row['M_Posted'];
etc....
OR
Use the php date (Don't know - haven't tried) functions to parse the
required values out of the Posted field.
HTH,
Bryan
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
