Ahmed Abdel-Aliem wrote:
> 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");
http://php.net/mysql_num_rows
> $record=mysql_fetch_array($test_tr);
Or, simply use something like:
if ($record != false){
> $ART_File_Name = $record['ART_File_Name'];
> $Art_Status = $record['Art_Status'];
> $Art_Creation_Date = $record['Art_Creation_Date'];
> $Art_ID = $record['Art_ID'];
}
Read http://php.net/mysql_fetch_array
> 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
>
>
--
Like Music?
http://l-i-e.com/artists.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
