[RESOLVED] Hard time with "WHILE LOOP"

Nookzor

Hello , the problem is simple but i can't find the solution.

The db items : name , age , bool ( bool being a bool ).
The php code :

<? // Connect to db
     $result = mysql_query("SELECT * FROM db");			
     $count = mysql_num_rows($result);
	if($count >= 1)
{
	while ($row = mysql_fetch_array($result)) 
		  {

		echo $row['name'];
                    echo $row['age'];
                    echo $row['bool'];
               }
}
mysql_close($con);

Now instead of displaying zeros and ones for the BOOL , i want to display an image , if the bool is 1 a check img and if the bool is 0 an x img as in 'Passed' and 'Failed'.

I tryed adding the following code in the while loop :

 
if ($row['bool'] = 1) { $bool = <img check bla bla>; }
else { $bool = <img x bla bla>; }

and replaced $row['bool'] with $bool in the loop.But it just changes all the values for $bool with the check image ignoring the '0' values.
Can anyone help ?

ShawnK

This is because in your if statement you are checking to see if $row['bool'] is set to 1, if it is the script stops there because the else is never executed. What you need to do is to seperate if statements.

while($row = mysql_fetch_array($result))
{
  if($row['bool'] === 1){ echo "<img>check</img><br />"; }
  if($row['bool'] === 0){ echo "<img>uncheck</img><br />"; }
}

Nookzor

Works just fine thx.

ShawnK

No problem. Make sure to mark this thread resolved.

bradgrafelman

Note that your original code would work just fine if you had used the correct operator. You used a single '=' sign, meaning "If you can change the value of bool to 1"...

What you needed to do was use 2 equal signs, which is a comparison operator.