problem in mysql_fetch_array

[zedan_80]

Hallo

i have a problem in mysql_fetch_array, i got the following error msg

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in

$num_rows = mysql_num_rows($qry);

if($num_rows > 0){
while($res = mysql_fetch_array($qry)){
///some staff here
}
}

[gammaster]

Hi!
It seams that your '$qry' isn`t a query result.

Check it like this:

if(!is_resource($qry) || get_resource_type($qry) != 'mysql result') {
   echo 'The var $cry isn`t a query result';
   {
else if(mysql_num_rows($qry) > 0) {
   while($res = mysql_fetch_array($qry)){
   ///some staff here
      }
   }

[zedan_80]

here is my $qry
$qry = "select id , login_name , join_date from login where status=0" ;

when i removed the $num_rows = mysql_num_rows($qry);

its works fine
is it right that mysql_num_rows cleans the buffer?????

[herve]

It works fine because you aren't using anymore the result of your query 🙂

The problem is in the query. Try putting :

print mysql_error();

just after your mysql_query() call to see the exact error message.

May be some misspelled column name in your login table.