using check boxes with relational db

[Anon]

Hi there,

I'm trying to have a table of checkboxes where all of the values are from the db.

If the value is selected i want it to be checked.

This is what i have at the moment but it keeps giving me a parse error on the marked line.

I'm still new to php and cant see the problem.

<?php

$db = mysql_connect("localhost", "root");

mysql_select_db("fjc",$db);

$res2 = mysql_query("SELECT barristers.bar_id, bar_admis.bar_id, admissions.admis_id, admissions.admission FROM admissions, bar_admis, barristers WHERE (barristers.bar_id = bar_admis.bar_id) and (bar_admis.admis_id = admissions.admis_id",$db);

$cols = 4;
$counter = 1;

print '<table width=\"40%\" cellspacing=\"4\"><tr>';
while ($myrow = mysql_fetch_array($res2)) {
if (is_int($counter / $cols)) {

?>
*********** <td><input type="checkbox" name="<? echo ($myrow["admissions.admis_id"]); ?>" <? if ($myrow["bar_admis.bar_id"]) != 0 { echo ("checked");} ?>><span class="text"><? echo($myrow["admissions.admission"]); ?></span></td></tr><tr>

<?
}
else {
?>

<td><input type="checkbox" name="<? echo ($myrow["admissions.admis_id"]); ?>" <? if
 ($myrow["bar_admis.bar_id"]) != 0 { echo "checked";} ?>><span class="text"><? echo ($myrow["admissions.admission"]); ?></span></td>

<?
}
$counter++;
}
print '</tr></table>';

?>

thanks,

dunskii

[Anon]

Your problem is that a parenthesis has come adrift:

if($myrow[...])!=0 should be if($myrow[...]!=0)

Incidentally, another problem you'll have is that because $cols and $counter are both integers, $counter/$cols is also always an integer. Recommend you change is_int($counter/$cols) to ($counter%$cols==0).

[Anon]

thanks for that,

it is now saying:
Supplied argument is not a valid MySQL result resource

for this line:

while ($myrow = mysql_fetch_array($res2)) {

i thought it was because i had a $res2 where it shouldn't have been, but it wasn't.

thanks for you help,

dunskii

[Anon]

Try echoing mysql_error() immediately after the my_sql query, and see if MySQL is complaining about something.