Trying to use conditionals on mysql results

[burntheblobs]

I want to try and create a conditional that checks if anything is returned by a mysql query. For example something like this:

 

$query = "SELECT School_Name FROM school WHERE schoolName='$school'";
$result = mysqli_query($cxn,$query)
or die ("Couldn't execute query.");
extract(mysqli_fetch_assoc($result));	

if (extract(mysqli_fetch_assoc($result)) = "")
{
    Do things
}

 

But it isn't working. Any ideas?

[n3ightjay]

try

 

$query = "SELECT School_Name FROM school WHERE schoolName='$school'";
$result = mysqli_query($cxn,$query)
or die ("Couldn't execute query.");
extract(mysqli_fetch_assoc($result));	

if (extract(mysqli_fetch_assoc($result)) != 0)
{
    Do things
}

[wildteen88]

This is not the correct way. You should use mysql_num_rows as shown here