Aaron4osu Posted December 27, 2011 Share Posted December 27, 2011 I'm trying to check the number of results returned in a query. Currently there is one result being returned but i'm getting this error when I try to run line 38: $num_rows = mysql_num_rows($ratings); Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/haas12/public_html/login/rateVideo.php on line 38 Rows $ratingsQuery = "SELECT * FROM haas12_test.ratings "; $ratings = mysqli_query($conn, $ratingsQuery) or die ("Couldn't execute query."); $num_rows = mysql_num_rows($ratings); echo "$num_rows Rows\n"; Link to comment https://forums.phpfreaks.com/topic/253904-help-with-mysql_num_rows-error/ Share on other sites More sharing options...
Pikachu2000 Posted December 27, 2011 Share Posted December 27, 2011 You can't mix mysql_* extension functions with mysqli_* extension functions. Link to comment https://forums.phpfreaks.com/topic/253904-help-with-mysql_num_rows-error/#findComment-1301654 Share on other sites More sharing options...
kleb Posted December 27, 2011 Share Posted December 27, 2011 why dont you use mysql instead of mysqli Link to comment https://forums.phpfreaks.com/topic/253904-help-with-mysql_num_rows-error/#findComment-1301687 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.