populating a checkbox from database

[eluser]nikefido[/eluser]
Hmmm the answer to this seems to be specific to your business logic.

I would create a function within the model you use to call the database query (assuming you handle database calls from a model class) that checks if a product would require a check.

Code:

//possible implementation
<?php  foreach ($query2->result() as $row):?>
<?php if($check = $this->yourmodel->shouldCheckBox($row->product_id)) : ?>
    <p>&lt;?php echo form_checkbox('product', true, set_checkbox());?&gt;
    &lt;?php //$row->product_id; ?&gt;
    &lt;?php echo $row->product; ?&gt;</p>
&lt;?php endif; ?&gt;
&lt;/form&gt;
&lt;?php endforeach ?&gt;

Upon seeing your code, you might be already doing this with your "set_checkbox()" function. However, I'm not sure that your syntax is correct for the form_checkbox();
According to docs, it goes like this:

Code:

//from the docs
$js = 'onClick="some_function()"';

echo form_checkbox('newsletter', 'accept', TRUE, $js)

where you're implementation skips the argument where "accept" goes. You should pass it a default parameter.