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"; Quote 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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.