record fetching error
| From: | Ahmed Abdel-Aliem | Date: | Mon, 13 Dec 2004 11:46:30 +0000 |
| Subject: | record fetching error | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-204153@lists.php.net to get a copy of this message | ||
hi
i have a table in my database which i try to fetch rows from it
here is the code i am using
@ $db = mysql_connect ($server, $user, $pass);
mysql_select_db($database);
$test_tr = mysql_query("select * from art WHERE Game_ID = '$Game_ID'
desc LIMIT 1");
$record=mysql_fetch_array($test_tr);
$ART_File_Name = $record['ART_File_Name'];
$Art_Status = $record['Art_Status'];
$Art_Creation_Date = $record['Art_Creation_Date'];
$Art_ID = $record['Art_ID'];
the problem is when there is no row with the given Game_ID, i get a mysql error.
how can i get rid of that error !!!!