Getting a tick in a checkbox

[sdm]

Hi,

I have a value in a database table of 'N' or 'Y', if the value is 'Y' I want a checkbox on the page to have a tick in it.

How can I get this value to be the checkbox value?

Thanks for your time.

SDM

[Sxooter]

Let's say that the value is stored in a row called ok:

<FORM name="yourform">
<input name="ok" type="checkbox"
<?php
$query = <build query here>;
$res = mysql_query($query);
$ok = mysql_result($res,0,"ok");
if ($ok="Y") print " CHECKED";
?>

<BR>
<input type="submit">
</FORM>

[sdm]

Thank you for your reply, it is appreciated.

SDM

[edwardsbc]

Just one obvious typo:

if ($ok=="Y") print " CHECKED";

previous code ALWAYS added "checked" to the checkbox because the ASSIGNMENT (single equals sign) always returned true...