How do I change boolean output from query to text value in table

[capella07]

I have a query in a PHP/MySQL Web application that is returning (among other things), into a dynamically-built HTML table, the boolean column "IsOnTime" as a 1 or 0.

 

The HTML table is being built like this:

echo '<table>'
        while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
{
	echo '<tr>
		<td align="left">' . $row['IsOnTime'] . '</td>
	</tr>';
}
// Close the table
echo '</table>';

I would like to display the boolean fields as a "Yes" or "No".

 

How can I do that?

 

(I actually have four boolean fields I'll need to do that to...)

 

Thanks for anyone's help!

[salathe]

You could use the ternary operator like ... ($row['isOnTime'] ? 'Yes' : 'No') ...

[capella07]

That did the trick!

 

Thanks a lot, salathe.