i need help with a php registration form?

D

darkgamer9986

New member
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dark/public_html/ApplesLoginV1/register.php on line 22
THAT IS THE ERROR I AM GETTIN LINE 22 IS NOT TO FAR DOWN BUT I POSTED THE WHOLE CODE FOR THE LOGIN PLEASE AND THANK YOU FOR ANY HELP YOU CAN OFFER
<?php

echo "<div id='regtitle'><center><h1>Register</h1></center></div>";

$submit = $_POST['submit'];
$username = strtolower(strip_tags($_POST['username']));
$firstname = strip_tags($_POST['firstname']);
$lastname = strip_tags($_POST['lastname']);
$address = strip_tags($_POST['address']);
$homenumber = strip_tags($_POST['homenumber']);
$cellnumber = strip_tags($_POST['cellnumber']);
$password = strip_tags($_POST['password']);
$repeatpassword = strip_tags($_POST['repeatpassword']);
$email = strip_tags($_POST['email']);
$date = date ("Y-m-d");

if ($submit)
{
include ('connect.php');

$namecheck = mysql_query ("SELECT username FROM user WHERE username='$username'");
$count = mysql_num_rows($namecheck); // THIS IS LINE 22

if ($count!=0)
{
die ("The username you have chosen is already in use. Please try again with a different username.");
}

if ($username&&firstname&&lastname&&address&&homenumber&&cellnumber&&$password&&repeatpassword&&email)
{
if (strlen($username)>25)
{
echo "Your username has exceeded the maximum amount of characters. Please enter a smaller username.";
}
if (strlen($firstname)>25)
{
echo "Your first name has exceeded the maximum amount of characters. Please enter a smaller first name.";
}
if (strlen($lastname)>25)
{
echo "Your last name has exceeded the maximum amount of characters. Please enter a last name.";
}
if (strlen($address)>100)
{
echo "Your address has exceeded the maximum amount of characters. Please enter a smaller address.";
}
if (strlen($homenumber)>10)
{
echo "Your home phone number has exceeded the maximum amount of characters. Please enter a smaller home phone number.";
}
if (strlen($cellnumber)>10)
{
echo "Your mobile phone has exceeded the maximum amount of characters. Please enter a smaller mobile phone number.";
}
if (strlen($email)>100)
{
echo "Your email address has exceeded the maximum amount of characters. Please enter a smaller email address.";
}
if ($password==$repeatpassword)
{
if (strlen($password)>32||strlen($password)<6)
{
echo "Your password must be between 6 and 32 characters long.";
}
else
{
$password = md5($password);
$repeatpassword = md5($repeatpassword);

$queryreg = mysql_query("
INSERT INTO users VALUES ('','$username','$firstname','$lastname','$address','$homenumber','$cellnumber','$password','$email','$date')
");
die ("You have been successfully registered. An email has been sent to".$email."with deatils on how to activate your account. Click <a href='index.php'>here</a> to return to the main page.");
}
}
else
echo "Your password do not match.";

}
else
echo "Please fill in all of the required fields.";
}

?>

<html>
<p>
<div><center><form action="register.php" method="POST">

<table>
<tr>
<td>
Username:
</td>
<td>
<input type='text' name='username' value='<?php echo $usernamae ?>'/>
</td>
</tr>
<tr>
<td>
First Name:
</td>
<td>
<input type='text' name='firstname' value='<?php echo $firstname ?>'/>
</td>
</tr>
<tr>
<td>
Last Name:
</td>
<td>
<input type='text' name='lastname' value='<?php echo $lastname ?>'/>
</td>
</tr>
<tr>
<td>
Address:
</td>
<td>
<input type='text' name='address' value='<?php echo $address ?>'/>
</td>
</tr>
<tr>
<td>
Home Phone Number:
</td>
<td>
<input type='text' name='homenumber' value='<?php echo $homenumber ?>'/>
</td>
</tr>
<tr>
<td>
Mobile Phone Number:
</td>
<td>
<input type='text' name='cellnumber' value='<?php echo $cellnumber ?>'/>
</td>
</tr>
<tr>
<td>
Password:
</td>
<td>
<input type='password' name='password' />
</td>
</tr>
<tr>
<td>
Repeat Password:
</td>
<td>
<input type='password' name='repeatpassword' />
</td>
</tr>
<tr>
<td>
Email:
</td>
<td>
<input type='text' name='email' value='<?php echo $email ?>'/>
</td>
</tr>
<tr>
<td>
</td>
<td>
<input type='submit' name='submit' value='Register' />
</td>
</tr>
</table>

</form>
</center>
</div>

</html>
i changed the code to
if ($submit)
{
include ('connect.php');

$namecheck = mysql_query ("SELECT username FROM user WHERE username='$username'");
$count = mysql_query($namecheck) or die("Error: ".mysql_error(). " with query ". $query);
// $count = mysql_num_rows($namecheck);

if (mysql_num_rows($count) !=0)
{
die ("The username you have chosen is already in use. Please try again with a different username.");
}

and the error was
Error: Query was empty with query
 
Back
Top