i’m getting this error Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\update.php on line 16
[code]<?php
$english_name = $_POST[‘EnglishName’];
$tel_number = $_POST[‘TelNumber’];
$email_address = $_POST[‘EmailAddress’];
$gender = $_POST[‘Gender’];
$age = $_POST[‘Age’];
$region = $_POST[‘Region’];
$conn = mysql_connect(“localhost”,“root”,"") or die (“Cannot connect!”);
mysql_select_db(“form”) or die(“cannot find the db”);
$query = mysql_query(“SELECT * FROM form WHERE EnglishName=’$english_name’”);
if($english_name == “”)
{
echo ‘ERROR: No username filled in.’;
}
elseif(mysql_num_rows($query)==1)//error
{
echo ‘ERROR: This username already exists.’;
}
else
{
$sql = ‘INSERT INTO form (english_name, tel_number, email_address, gender, age, region) VALUES ("’.$english_name.’", “’.$tel_number.’”, “’.$email_address.’”, “’.$gender.’”, “’.$age.’”, “’.$region.’”)’;
$result = mysql_query($sql) or die(mysql_error());
echo “Your account has been successfully created. Enjoy! Return to login page”;
}
?>[/code]