WampServer

I am using the function mysql_num_rows() and I have received the Warning:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\final\resultUsers.php on line 32


Look at my code:

mysql_select_db('item');
$query = "SELECT * FROM item WHERE ".$tipoProcura." LIKE '%".$termoProcura."%'";
$result = mysql_query($query);

$num_results = mysql_num_rows($result); <------------
echo '<p> Número de itens encontrados: '.$num_results.'</p>';


I think it's a PHP5's problem..

$conn = mysql_connect ('localhost', 'username', 'password');

mysql_select_db('item', $conn);

$query = "SELECT * FROM item WHERE ".$tipoProcura." LIKE '%".$termoProcura."%'";

$result = mysql_query($query, $conn);

$num_results = mysql_num_rows($result);



CyberSpatium
WAMP English Forum Admin

Try to print your $query variable.

mysql_select_db('item');
$query = "SELECT * FROM item WHERE ".$tipoProcura." LIKE '%".$termoProcura."%'";
print $query;
$result = mysql_query($query);

And try:

$result = mysql_query($query) or die(mysql_error());

to see if your query have a error.



Post Edited (11-03-06 21:02)