meamrussian Posted April 21, 2006 Share Posted April 21, 2006 I am building a project and learning PHP/MySQL at the same time. Here is my code:$query = "SELECT suite, title, category, our_url FROM business ORDER BY category ASC";$result = mysql_query($query);$num_results = mysql_num_rows($result);<table width="100%"><tr><td width="63"><u>Suite</u></td><td><u>Business</u></td><td><u>Category</u></td><td> <u>Link</u></td></tr><?for ($i=0; $i <$num_results; $i++){ $row = mysql_fetch_array($result); echo "<tr><td>"; echo htmlspecialchars(stripslashes($row["suite"])); echo "</td><td>"; echo htmlspecialchars(stripslashes($row["title"])); echo "</td><td>"; echo htmlspecialchars(stripslashes($row["category"])); echo "</td><td>"; echo htmlspecialchars(stripslashes($row["our_url"])); echo "</td></tr>";}?></table>I am getting the following error:=====Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [b]my directory[/b] on line 47=====I have already connected to my database. I am using PHP 4.Also, even if I try to replace mysql_num_rows($result) with "2" , I get the same errors except with mysql_fetch_array(): . Why is this happening?Thanks. Link to comment https://forums.phpfreaks.com/topic/8016-solved-mysql_num_rows-function-error/ Share on other sites More sharing options...
kenrbnsn Posted April 21, 2006 Share Posted April 21, 2006 That error means the mysql_query is not working correctly. Replace [code]<?php $result = mysql_query($query); ?>[/code] with [code]<?php $result = mysql_query($query) or die('Problem with query: ' . $query . '<br />' . mysql_error()); ?>[/code] and see if an error message appears on your screen.Ken Link to comment https://forums.phpfreaks.com/topic/8016-solved-mysql_num_rows-function-error/#findComment-29227 Share on other sites More sharing options...
meamrussian Posted April 21, 2006 Author Share Posted April 21, 2006 Ah, I've figured out my problem now.Thanks. Link to comment https://forums.phpfreaks.com/topic/8016-solved-mysql_num_rows-function-error/#findComment-29234 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.