Warning: mysql_num_rows( ): supplied argument is not a valid MySQL result resource

[petemaxi]

Warning: mysql_num_rows( ): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htd ocs\tockholes\i ncludes\menu.in c.php on line 9

<div class="left">
<div class="menu">
<div class="boxhead" style="text-align:center;"> <strong>Menu</strong> </div>
<br />
<?php
require ('includes/db_conn.inc.php ');
$query = "select * from menu order by item_order";
$result = mysql_query($qu ery);
$num_results = mysql_num_rows( $result); <--- HERE!
for ($i=0; $i <$num_results ; $i++)
{
$row = mysql_fetch_arr ay($result);
echo '<tr>
<td align="left" nowrap="nowrap" >';
if (($row['sub']) == 'no') {
echo '<a href="';
echo ($row['url']);
echo '">';
echo ($row['name']);
echo '</a>';
}
else {
echo '- <a style="font-size:11px" href="';
echo ($row['url']);
echo '">';
echo ($row['name']);
echo '</a>';
}
echo '</td></tr>';
}
?>
</div>


Please help. I keep getting that error message.

Code previously worked, and now isn't. Racking my brains, and can't seem to find a fault.

Thanks

Pete

[ronverdonk]

Warning: you must enclose your code within the appropriate php, code or html tags! Please read the Posting Guidelines at the top of this forum before you post anything again.

To answer your question: you better find out first whether the SELECT generated an error, so change you mysql_query to the following and see what error message it throws.[php]$result = mysql_query($qu ery)
or die ("SELECT error: ".mysql_error() );
[/php]
Ronald :cool:

[khalidbaloch]

this might be syntax error ,add die mysql_error() function in every
mysql_query ,to figure out the mistake

you should also add this mysql_connect and dl_select in db_conn_ini.php
this code might

<?php
//load the db_conn_ini file
require ('includes/db_conn.inc.php');
$query = "select * from menu order by item_order";
$result = mysql_query($query) OR die(mysql_error());
$num_results = mysql_num_rows($result) OR die(mysql_error());  // 
while ($row = mysql_fetch_array($result))
while ($row = mysql_fetch_array($result))
{
echo '<tr>
<td align="left" nowrap="nowrap">';
 if ($row['sub'] == 'no') {
echo '<a href="',$row['url'],$row['name'],'"</a>'; 
}
else {
echo '- <a style="font-size:11px" href="',$row['url'],$row['name'],'</a>';          
}
 
echo '</td></tr>';
} 
?>

the code for db_conn_ini.php

<?
// SET MYSQL INFORMATION
$db_host = "localhost";
$database = "database";
$db_user = "root";
$db_pass = "dbpasswd";
 
// CONNECT TO MYSQL DATABASE
$db = mysql_connect($db_host, $db_user, $db_pass) OR die(mysql_error()) ;
mysql_select_db("$database") Or die(mysql_error());
?>
 

i made some changes to code so that it look better and i hope this will help you

[petemaxi]

Thank you for your help, all working now!