mysql_num_rows()

[phpdesp]

<?php

  $dbConnection = mysql_connect('localhost', 'root', NULL);
  mysql_select_db('aa', $dbConnection);
  $resource = mysql_query('SELECT * FROM qlist ORDER BY part ASC', $dbConnection);
  $rows =  mysql_num_rows($resource);

  $result = NULL;


for ($i=0; $i<$rows; $i++) {
   $row = mysql_fetch_object($resource);

   $result = $row->name;
   $result = $row->email;
   $result = $row->password;
   $result = $row->country;
}

print $result;
?>

I get this:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\www\login\show.php on line 12

What's wrong? I got this same piece of code with $result etc. working in another script, but seems not to work here.

[laserlight]

Your query could be incorrect.

Try something like:

<?php

$dbConnection = mysql_connect('localhost', 'root', NULL)
	OR die("Could not connect to DB server");
mysql_select_db('aa', $dbConnection)
	OR die("Could not select DB");
$resource = mysql_query('SELECT * FROM qlist ORDER BY part ASC', $dbConnection)
	OR die(mysql_error());
$rows =  mysql_num_rows($resource);

$result = NULL;


for ($i=0; $i<$rows; $i++) {
	$row = mysql_fetch_object($resource);

$result = $row->name;
$result = $row->email;
$result = $row->password;
$result = $row->country;
}

print $result;
?>

to help you debug.

[tekky]

Originally posted by phpdesp
.....I get this:


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\www\login\show.php on line 12

What's wrong? I got this same piece of code with $result etc. working in another script, but seems not to work here.

I've had this happen before, ended up just cutting and pasting the working db code in and renaming the vars in the pasted code to match....

worked after that, but I would definately try Laserlights suggestion to find out what is really happening

[phpdesp]

Ok, fixed it. It was the "ORDER by part" the part is a column that doesnt exist in this particular table.