Page 1 of 1

empty() functionality

Posted: Tue Feb 23, 2010 12:08 am
by anon404
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;
    }
}

Re: empty() functionality

Posted: Tue Feb 23, 2010 12:10 am
by s.dot

Code: Select all

$query = "SELECT rawTitle FROM movies WHERE rawTitle='$movie'";
How is that empty() ? :P

Re: empty() functionality

Posted: Tue Feb 23, 2010 12:39 am
by anon404
LOL oh dear, i shouldn't be on the computer until i've been awake for at least 30 minutes 8O :oops: :P