checkbox checking..

G'day all: Using php4.0.3pl1 I have a column in a MySQL table that is set to char(1) and is either empty or 'y' (if anyone knows of a better dual choice column type I'd be pleased to hear about it...however...) In my update script I want a checkbox to be display as checked if 'y' is set in the afformentioned table. (The update script first SELECTS then displays the results in form fields in order to enable altering of their the contents (UPDATE/DELETE etc) All the other field types ( <select></select> and <input type="text" yadda yadda> ) are fine just the checkbox refuses to tell me the status of the column ('y' or empty) This is the script snippet I thought may do it but doesn't: while($chk_row = mysql_fetch_array($chk_result, $connection)) { $ischkd = $chk_row['chk']; if(!empty($ischkd)) { $chkbox = "<input type=\"checkbox\" name=\"enable_sign\" value=\"yes\" checked>"; } else{ $chkbox = "<input type=\"checkbox\" name=\"enable_sign\" value=\"yes\">"; } } //end-while echo "<td>$chkbox</td> /* Should echo as a checked-checkbox if 'y' exists in the table (the 'if') Or an unchecked-checkbox (the 'else') if 'y' doesn't exist or the result is empty. */ I have also tried doing: $num = mysql_num_rows($chk_result); if($num != 'y') { $chkbox = "<input type=\"checkbox\" name=\"enable_sign\" value=\"yes\" checked>"; } else{ $chkbox = "<input type=\"checkbox\" name=\"enable_sign\" value=\"yes\">"; } //But this don't work either!!?? Any suggestions are most welcome as the more coffee I consume the less rational my thought processes become!! Cheers! Russ #-------------------------------------------------------# "Believe nothing - consider everything" "Web Developers do it on-the-fly." Russ Michell Anglia Polytechnic University Webteam www.apu.ac.uk/webteam r.j.michell@apu.ac.uk +44 (0)1223 363271 ext 2331 www.theruss.com #-------------------------------------------------------#