[RESOLVED] Need help with select count

[pneudralics]

I can't figure out why my if statement always echos no even when the array does not find anything.

If I do $array == 0 it always echos yes and never no.

$result = mysql_query("SELECT COUNT(*) FROM title WHERE title LIKE '%blue%'");
$array = mysql_fetch_array($result);
echo $array[0];

if ($array = 0) {
echo "yes";
}
else {
echo "no!";
}

I want the if statement to say yes if the result is 0 and say no if the result is 1 or more.

[laserlight]

In this case, if I really had to use the MySQL extension, I would use mysql_result(), e.g.,

$result = mysql_query("SELECT COUNT(*) FROM title WHERE title LIKE '%blue%'");
$count = mysql_result($result, 0);
echo $count;

if ($count == 0) {
    echo "yes";
}
else {
    echo "no!";
}

Note that I write $count == 0 instead of $count = 0, which corresponds to a fix to your problem.

[pneudralics]

Thanks