Warning: mysql_num_rows() expects parameter

[zhshero]

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\ipod\lib\connection.php on line 131

 

:S

129. 	function RecordCount ( $query )
130.		{
131.			return mysql_num_rows( mysql_query( $query ) );
132.		}

 

[bh]

The problem is with your query. The error contains "boolean given" so your query probably returns false.

For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a resource on success, or FALSE on error.

 

For other type of SQL statements, INSERT, UPDATE, DELETE, DROP, etc, mysql_query() returns TRUE on success or FALSE on error.