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'?
Advertising
<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
