PHP/QUERY Error
Posted: Sat Aug 21, 2010 9:49 pm
I keep getting an error message but I can't seem to find what I'm messing up here.
<?php
$username = $_POST["username"];
$password = $_POST["password"];
if ($username&&$password);
{
$connect = mysql_connect("localhost","XXXXX","XXXXXX") or die("Couldn't connect!");
mysql_select_db("mypower5_members") or die("Couldn't find db");
$query = mysql_query("SELECT * FROM users WHERE username="$username"");
$numrows = mysql_num_rows($query);
echo $numrows;
}
else
die("Please enter username and password!");
?>
I would appreciate any help.
Thanks
My code:Parse error: syntax error, unexpected T_VARIABLE in /home/mypower5/public_html/login2.php on line 12
<?php
$username = $_POST["username"];
$password = $_POST["password"];
if ($username&&$password);
{
$connect = mysql_connect("localhost","XXXXX","XXXXXX") or die("Couldn't connect!");
mysql_select_db("mypower5_members") or die("Couldn't find db");
$query = mysql_query("SELECT * FROM users WHERE username="$username"");
$numrows = mysql_num_rows($query);
echo $numrows;
}
else
die("Please enter username and password!");
?>
I would appreciate any help.
Thanks