$Rows = mysql_num_rows($Result); problem

[Anon]

Hello, I have the following code:

if ($Validate=="True")
{
$SQL = "select Username from users where Username=$Username";
$Result = mysql_db_query($DB, $SQL, $Connection);
$Rows = mysql_num_rows($Result);
if ($Rows < 1)
{
print "<br>This username already exists.";
}
else
{
print "<br>This username is unique.<br>";
}

}

But for some dark reason the code crashes at the line of $Rows = mysql_num_rows($Result);
saying 0 is not a MySQL index ....

Does anyone knows what's wrong with this code?

Patrick

[Anon]

Try this:

if ($Validate=="True")
{
$SQL = "select Username from users where Username='$Username'";
$Result = mysql_db_query($DB, $SQL, $Connection);
$Rows = mysql_num_rows($Result);
if (!$Rows || $Rows < 1)
{
print "<br>This username already exists.";
}
else
{
print "<br>This username is unique.<br>";
}
}

[Anon]

Yeah it worked! Thanks !

But could explain the line

if (!$Rows || $Rows < 1)

To me?

Patrick

[Anon]

if (!$Rows || $Rows < 1)

In some version of PHP I had problems if the variable $Rows hadn't been created. When I write !$Rows it says: if $Rows hasn't been created/assigned value then go...

You can probably drop it if you want.