Why This error in Linux Server????

[chanchelkumar]

Hi all,,

 

Am always getting this error in my linux server....

 

bUt no issue in my windows server!!!

 

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

 

 

 

[drisate]

You query is probably wroung.

Can you post the query string inserted into mysql_num_rows

[chanchelkumar]

<?php 
$usrid=$_GET['usrid'];
$sessionvar=$_SESSION['usid'];
connect_to_db();
$block="select * from cw_blocklists where blkd_userid=$sessionvar and blker_usid=$usrid";
$result=mysql_query($block)or die (mysql_error());
$rows=mysql_num_rows($result);

if($rows>0)
{
?>
<script language="javascript">
alert("You are a Blocked user");

history.go(-1);//for go to just back of the page 
</script>
<?php
//header ("Location:client/blocked_message.php");
}
else
{
**********my code goes here****

}

[drisate]

Try this

 

<?php 
$usrid=$_GET['usrid'];
$sessionvar=$_SESSION['usid'];
connect_to_db();
$block="select * from cw_blocklists where blkd_userid=$sessionvar and blker_usid=$usrid";
$result=mysql_query($block)or die (mysql_error());

if (mysql_num_rows($result)) {
{
?>
<script language="javascript">
alert("You are a Blocked user");

history.go(-1);//for go to just back of the page 
</script>
<?php
//header ("Location:client/blocked_message.php");
}
else
{
**********my code goes here****

}