Im trying to use this code but its not working for some reason...
Errorcode: Warning: mysql_num_rows() expects parameter 1 to be resource, line number 27
the code im using:
<?php
include("db.php");
$lname = $_POST['lname'];
$fname = $_POST['fname'];
$mname = $_POST['mname'];
$adress = $_POST['address'];
$gender = $_POST['gender'];
$nationality = $_POST['nationality'];
$religion = $_POST['religion'];
$contact = $_POST['contact'];
$email = $_POST['email'];
$school = $_POST['school'];
$year = $_POST['year'];
$schooladd = $_POST['schooladd'];
$schoolid = $_POST['schoolid'];
$database = $school;
mysql_select_db("$database", $con);
$ID = str_replace(' ', '_', $lname.$schoolid);
//check if id already exist
$check = mysql_query("SELECT * from wup WHERE Schoolid = '$schoolid'");
if (mysql_num_rows($check) > 0) {
echo "User Already Exist";
}
else
{
$sql = "INSERT INTO scholars (ID, Schoolid, Lastname, Firstname, Middlename, Address, Gender, Nationality, Religion, Contact, Email, School, Year, Schooladdress)
VALUES ('$ID', '$schoolid', '$lname', '$fname', '$mname', '$adress', '$gender',
'$nationality', '$religion', '$contact', '$email', '$school', '$year', '$schooladd')";}
mysql_query($sql,$con);
mysql_close($con);
?>