Menu
Community /Pin to ProfileBookmark
@NogDogSep 16.2005 — #The "supplied argument is not a valid MySQL result resource" message tells you that the query failed to execute; either there was a syntax error in the query or you are not connected to the database. To debug, try changing your mysql_query line to:
Checking Username
I have the following code and have problem that it gives me
result :
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in…it works if this is alone but when I put into my web site script it shows me this message. Could you help me what can be wrong?
my Code:
//search for name
$un = $_POST[‘username’];
$query = “SELECT username FROM login WHERE username=’$un’ LIMIT 1”;
$result = mysql_query($query);
$num_rows = mysql_num_rows($result); //Check how many rows are in result
if($num_rows > 0) {
echo “This $un is in DataBase”;
}
else {
echo “This $un is not correct”;
}
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogSep 16.2005 — #The "supplied argument is not a valid MySQL result resource" message tells you that the query failed to execute; either there was a syntax error in the query or you are not connected to the database. To debug, try changing your mysql_query line to:[code=php]
$result = mysql_query($query) or die ("SQL error: $query -- " . mysql_error());
[/code]