Query works but can't echo variable :'(
| From: | Graeme McLaren | Date: | Mon, 27 Oct 2003 00:22:19 +0000 |
| Subject: | Query works but can't echo variable :'( | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31307@lists.php.net to get a copy of this message | ||
Hey everyone, the following query and code works fine but I can't understand
why I can't echo the $Date variable. I guess it doesn't work fine then :(
Any ideas ?
G :)
$TheDate = mysql_query("select DATE_FORMAT(DateOfOrder, '%d, %m, %Y') as
date from Orders Where Orders.ID = '$TransID'");
while($OrderDate = mysql_fetch_array($TheDate))
{
$Date = $OrderDate["DateOfOrder"];
}