[RESOLVED] Something wrong with my if statement...

gszauer

Hi guys,

if ($row['sold'] == 'false'){
echo '<td width="56"><img src="http://yourcapecoral.com/images/false.gif" border="0"></td>';
}else{
echo '<td width="56"><img src="http://yourcapecoral.com/images/teuse.gif" border="0"></td>';
}

Is there anything wrong with the above if statement?
$row['sold'] == 'false') - false is a string loaded from a database.....

If anyone can help, i'd greatly appriciate it
Thanks
~Gabor

Houdini

Well it could be the entry was False or FALSE or misspelled. Is this a VARCHAR field or is it a boolean which if that is the case it woul be 0 (zero) and not false or is it an ENUM field with values of true and false? It would be hard to answer much more than that.

gszauer

The script has worked in a previous version when i used fladh for it
its a varchar, and the entery is eather true, or false (all lower case)
my question is: is there anything wrong with the syntax?
I know in flash = sets a value, and == checks a valuse, so i used ==, but its not working, eaven the true values return false for some reason

samudasu

echo out $row['sold']. What does it say?

echo $row['sold'];
if ($row['sold'] == 'false'){
echo '<td width="56"><img src="http://yourcapecoral.com/images/false.gif" border="0"></td>';
}else{
echo '<td width="56"><img src="http://yourcapecoral.com/images/teuse.gif" border="0"></td>';
}

gszauer

it returns true once.
The full loop is

<?PHP 
while ($row = mysql_fetch_array($dbq)) {
echo '<tr>';
echo '<td width="193"><a href="homes.php?id='.$row['id'].'" target="_self"><img src="wizard/data/'.$row['p1'].'" width=190 height=150 border="0"></a></td>';
echo substr('<td width="400"> $ - '.$row['price'].'<br> '.$row['address'].', '.$row['city'].'<br> '.$row['description'].'</td>', 0, $number_of_chars);

echo $row['sold'];
if ($row['sold'] == 'false'){
echo '<td width="56"><img src="http://yourcapecoral.com/images/false.gif" border="0"></td>';
}else{
echo '<td width="56"><img src="http://yourcapecoral.com/images/teuse.gif" border="0"></td>';
} 

echo '</tr>';
}
?>

samudasu

($row['sold'] == 'false') and ($row['sold'] == false) will give you different results. In the first statement, true does equal 'false' becaue you quoted the word false. Read this page.
http://www.php.net/manual/en/language.types.boolean.php

gszauer

Thank you, that has really, really helped 🙂