else statement not executing

micmac

Hi all,
Can anyone tell me (from the code below) why the last else statement won't execute.
It successfully tells me if there is a duplicate url but won't display the final message if it is not a duplicate url.

$result = mysql_query ("SELECT * FROM $table WHERE url = '$url' GROUP BY url HAVING COUNT(url) > 1");

while ($row = mysql_fetch_array($result)){

if($result >= 2){

echo "This is a duplicate";
} else { 
echo "This is not a duplicate";
}
}

Cheers,
micmac

remote2

$result = mysql_query ("SELECT * FROM $table WHERE url = '$url' GROUP BY url HAVING COUNT(url) > 1");

i think $result is not an integer.. it's a resource...
maybe it always evaluate to true...

try..
mysql_num_rows ($result)
this should return a int

swr

In the case where there are no duplicates:
The query returns no rows, because COUNT is not greater than one, so the while loop condition is immediately not true (mysql_fetch_array returns null), so the body of the loop (the if statement) never gets executed.

swr

My explaination is what you are seeing, but remote2 is also correct. $result is a mysql query result index, not the number of rows returned. So you have two bugs in the posted code.

$result is an integer, but its value has no meaning except as a mysql query result. PHP internally maintains an array of mysql query result structures, and $result is just a value that is used as an index into that array, and has no meaning outside of that context.

To get the number of rows returned, use mysql_num_rows($result).