Hej jag försöker göra en koll om en användare redan finns i min databas
jag får detta felmeddelande:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/web77725l/domains/mycodez.se/public_html/testing/register.php on line 19
rad 19:
$count = mysql_num_rows($namecheck);
och här är hela koden
<?php
echo "<h1>Register</h1>";
$submit = $_POST['submit'];
//Form data
$fullname = strip_tags($_POST['fullname']);
$username = strtolower(strip_tags($_POST['username']));
$password = strip_tags($_POST['password']);
$repeatpassword =strip_tags($_POST['repeatpassword']);
$date = date("Y-m-d");
if ($submit)
{
// open database
$connect = mysql_connect("mysql66.kontrollpanelen.se","******","******");
mysql_select_db("web77725l_php");//select database
$namecheck = mysql_query("SELECT username FROM WHERE username='$username'");
$count = mysql_num_rows($namecheck);
echo $count;
die();
//Check for exiistance
if ($fullname&&$username&&$password&&$repeatpassword)
{
if($password==$repeatpassword)
{
// check char length of username and fullname
if(strlen($username)>25||strlen($fullname)>25)
{
echo "Length of username or fullname is too long!";
}
else
if (strlen($password)>25||strlen($password)<6)
{
echo "Password must be between 6 adn 25 characters";
}
else
{
//register the user!
//encrypt password
$password = md5($password);
$repeatpassword = md5($repeatpassword);
// open database
$connect = mysql_connect("mysql66.kontrollpanelen.se","web77725l_admin","flagga");
mysql_select_db("web77725l_php");//select database
$queryreg = mysql_query("
INSERT INTO users VALUES ('','$fullname','$username','$password','$date')");
die("You have been registered! <a href='index.php'>Return to login page</a>");
}
}
else
echo "Your password do not match!";
}
else
echo "Please fill in <b>all</b> fields!";
}
?>
<html>
<p>
<form action='register.php' method='POST'>
<table>
<tr>
<td>
Your full name:
</td>
<td>
<input type='text' name='fullname' value='<?php echo $fullname; ?>'>
</td>
</tr>
<tr>
<td>
Choose a username:
</td>
<td>
<input type='text' name='username'value='<?php echo $username; ?>'>
</td>
</tr>
<tr>
<td>
Choose a password:
</td>
<td>
<input type='password' name='password'>
</td>
</tr>
<tr>
<td>
Repeat your password:
</td>
<td>
<input type='password' name='repeatpassword'>
</td>
</tr>
</table>
<p>
<input type='submit' name='submit' value='Register'>
</p>
</form>
</p>
</html>
mycket tacksam för snabba svar
/Robin