empty() functionality
Posted: Tue Feb 23, 2010 12:08 am
I need to know why the empty function doesn't return true for $query (which is empty). I am using $row[0] instead because it is working as desired with empty();
Code: Select all
{
mysql_connect("localhost", "root", "password") or die(mysql_error());
mysql_select_db("bot") or die(mysql_error());
echo $movie . "<br/>";
$query = "SELECT rawTitle FROM movies WHERE rawTitle='$movie'";
$result = mysql_query($query);
$row = mysql_fetch_row($result);
echo "query col 1: " . $row[0] . "<br/>";
echo "query col 2: " . $row[1] . "<br/>";
echo "query col 3: " . $row[2] . "<br/>";
echo "query col 4:" . $row[3] . "<br/>";
if(empty($row[0])) {
return true;
}else{
return false;
}
}