[SOLVED] Checking if new does not work

[nathanmaxsonadil]

Hi I have a php script that checks if the data is new and if it is it put's it in a diffrent div then if it was read already

but it's not working!

here's the code.

while ($row1 = mysql_fetch_assoc($sql1)) {
if($row1['new'] == true) {
$message = $row1['message'];
echo "<div id='postsn'>{$message}</div><br/>";
$sql2 = "UPDATE streamline SET new='false' WHERE message='{$message}'";
$sql3 = mysql_query($sql2) or die(mysql_error());
}else if($row1['new'] == false) {
echo "<div id='postso'>{$row1['message']}</div><br/>";
}
}

I looked in the database and it said it was false.

[trq]

Your checking for booleens yet storing strings. Try...

 

if($row1['new'] == 'true') {

[nathanmaxsonadil]

now is display's nothing.....

 

[nathanmaxsonadil]

I only changed true that was my mistake