record fetching error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 !!!!

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux