I Get this error mysql_numrows(): supplied argument is not a valid MySQL re

[official.DJ.cabo]

I Get error like this when i start the host.

<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="jquery.watermarkinput.js"></script>
<script type="text/javascript">
$(document).ready(function(){

$(".search").keyup(function() 
{
var searchbox = $(this).val();
var dataString = 'searchword='+ searchbox;

if(searchbox=='')
{
}
else
{

$.ajax({
type: "POST",
url: "search.php",
data: dataString,
cache: false,
success: function(html)
{
$("#display").html(html).show();
    }
});
}return false;    


});
});

jQuery(function($){
   $("#searchbox").Watermark("Search");
   });
</script>
<style type="text/css">
body
{
font-family:"Lucida Sans";

}
*
{
margin:0px
}
#searchbox
{
border:solid 1px #000;
padding:3px;
margin-right: 437px;
background-image:url(images/search.jpg);
background-position:right;
background-repeat:no-repeat;
}
#display
{
display:none;
background-color:#627aad;

border-left:solid 1px #dedede;
border-right:solid 1px #dedede;
border-bottom:solid 1px #dedede;
overflow:hidden;
display: block;
margin-right: 438px; width: 254px;
}
.display_box
{
padding:4px;
border-top:solid 1px #dedede;
font-size:12px;
height:30px;
}
.display_box:hover
{
background:#CCFFFF;
color:#FFFFFF;
}
#shade
{
background-color:#00CCFF;
}
a:link {
    text-decoration: none;
}
a:visited {
    text-decoration: none;
}
a:hover {
    text-decoration: none;
}
a:active {
    text-decoration: none;
}
</style>
<div class="lefttop">

  <div class="lefttopleft"><a href="lol.php"><img src="images/logo.jpg" width="94" height="21" /></a></div>

  <div class="lefttoright">
  <a href="confirm.php"><img src="images/Untitled-1.png" width="15" height="15" border="0" /></a><?php 

$result = mysql_query("SELECT * FROM friendlist WHERE firstname='".$_SESSION['SESS_FIRST_NAME'] ."' and status='pending' ORDER BY firstname ");

    $numberOfRows = MYSQL_NUMROWS($result); 

    echo '<font size="2" color="red"><b>' . $numberOfRows . '</b></font>'; 
    ?>

        <a href="unread.php"><img src="images/messages.png" width="15" height="15" border="0" /></a>
        <?php 

$result = mysql_query("SELECT * FROM messages WHERE receiver='".$_SESSION['SESS_FIRST_NAME'] ."' and status='pending' ORDER BY receiver ");

    $numberOfRows = MYSQL_NUMROWS($result); 
    echo '<font size="2" color="red"><b>' . $numberOfRows. '</b></font>';
    ?>
  </div>
</div>

      <div class="righttop1">


<div class="search">
<input type="text" class="search" id="searchbox" />
<div id="display" >
</div>

  </div>

    <div class="nav"><ul id="sddm">

    <li><a href="lol.php" onmouseover="mopen('m3')" onmouseout="mclosetime()">Home</a>
        <div id="m3" onmouseover="mcancelclosetime()" onmouseout="mclosetime()">       </div>
    </li>
    <li><a href="profile.php" onmouseover="mopen('m4')" onmouseout="mclosetime()">Profile</a>
        <div id="m4" onmouseover="mcancelclosetime()" onmouseout="mclosetime()">       </div>
    </li>
    <li><a href="#" onmouseover="mopen('m5')" onmouseout="mclosetime()">Account</a>
        <div id="m5" onmouseover="mcancelclosetime()" onmouseout="mclosetime()">
        <a href="profile.php">   
        <?php 


$result = mysql_query("SELECT * FROM members WHERE FirstName='".$_SESSION['SESS_FIRST_NAME'] ."'");

echo "<br />";
while($row = mysql_fetch_array($result))
  {

  echo "<img width=50 height=50 alt='Unable to View' src='" . $row["profImage"] . "'>";
  echo '<br />';
  echo $_SESSION['SESS_FIRST_NAME']." ". $row["LastName"] ;

        //echo "<img width=50 height=50 alt='Unable to View' src='" . $row["location"] . "'>";
        //echo '<a href=http://localhost/PHP-Login/member-index.php?id=' . $row["friends_id"] . '>' . $row['firstname'] . '</a><br />';

  }

?></a>
        <a href="editfriends.php">Edit Friend</a>
        <a href="accountsettings.php">Account Setting</a> 
        <a href="friends.php">SearchFriend</a>
        <a href="index.php">Logout</a>          </div>
    </li>
</ul>
<div style="clear:both"></div>

<div style="clear:both"></div></div>

  </div>

Anyone knows how to fix this problem?

[dinhunzvi]

on which line

[dinhunzvi]

try using mysql_num_rows() instead of mysql_numrows() and see if you get the same error

[OsaMasw]

on line 116 use mysql_num_rows()

[dinhunzvi]

line 116 has MYSQL_NUMROWS( $result ). try this for that section of your code

$sql = "SELECT * FROM messages WHERE receiver='".$_SESSION['SESS_FIRST_NAME'] ."' and status='pending' ORDER BY receiver ";
$result = mysql_query( $sql ) or die( "Could not execute query: <br />" . mysql_error() );

[official.DJ.cabo]

thanks it works :)

[dinhunzvi]

mark as solved