mysql_num_rows() expects parameter 1 to be resource, boolean given in

[najbaan]

The below is my code.... it works from webserver, not works in local host

 

<?php
include "connect.php";
if(isset($_POST["signup"]))
{
 $un=$_POST["uname"];
 $pw=$_POST["pwd"];
 $fn=$_POST["fname"];
 $ln=$_POST["lname"];
 $eml=$_POST["email"];
 $ph=$_POST["phone"];
 $gen=$_POST["radiobutton"];
 $ad=$_POST["add"];
 /*$phot=$_FILES["photo"]["name"];
 move_uploaded_file($_FILES["photo"]["tmp_name"],'../photo/'.$phot);*/
 $res=mysql_query("select * from users where uname='$un'"); 
 /*or email='$eml'"*/
 $row=mysql_num_rows($res);
 if($row==0)
 {
 mysql_query("insert into users(rdate,uname,pwd,fname,lname,email,phone,gender,address,sdate)values(CURDATE(),'$un','$pw','$fn','$ln','$eml','$ph','$gen','$ad',CURDATE())");
 echo "<script language='javascript'>alert('Registration Successfull, An activation email will be send in 24 hours to your email account, Pleace check and confirm, Thanks')</script>";
 
 }
 else
 {
  echo "<script language='javascript'>alert('Username or email already registered before, Please use different username or email')</script>";
 }
}
?>

 

[Barand]

See forum FAQ

 

http://forums.phpfreaks.com/index.php?showtopic=273121