Hi I have a mysql table that has a field in it called 'DATETIMEADDED' which has data type 'datetime' I want to display the contents of the field on my page. I have tried usng the following code but the value in the 'DATETIMEADDED' only the value in the 'NAME' field which is a varchar is displayed on the page. How can i get it to display the value in 'DATETIMEADDED'?
<ul> <? $query = "SELECT * FROM `BOARDITEMS` WHERE BOARDID=$BOARDID ORDER BY 'DATETIMEADDED';"; $resultboarditems = mysql_query ($query) or die("Invalid Result Set"); while ($row = mysql_fetch_array ($resultboarditems)) { ?> <li><? echo $row["DATETIMEADDED"]; ?><? echo $row["NAME"]; ?></li> <? } ?> </ul> Thank you Charlie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php