i have a field in a table called Posted and it is a timestamp type
im using mysql and my page is supposed to take the timestamp field and show
it on the screen in the form of month#/dayofmonth/year
like 02/18/2003 the problem im having is trying to get it to be formatted..
i tried mysql functions like dayofmonth(Posted) month(Posted) and
year(Posted) in the query:
$query=mysql_query("select dayofmonth(Posted), month(Posted), year(Posted),
hour(Posted), minute(Posted), Name, Prayer from prayer");
this query works just fine but my question is now in php how to display the
results for dayofmonth(Posted) and so on further code follows:
while($view=mysql_fetch_array($query)) {
//display variables from query here...
//get to the date functions:
//$view[month(Posted)]/... doesnt work
//php complains about missing ] and this doesnt work
//either
while($view=mysql_fetch_object($query)){
//show variables here..
//show date fields in table...
//$view->dayofmonth(Posted) doesnt work either all i get
//in display is (Posted)
...rest of code here...
?>
and its strange because if i try: echo $view->dayofmonth(Posted); i get
parse error call to undefined function dayofmonth() in file.php on line
(line #)
any ideas on how to get this to work?
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
