Best way to populate an edit form from a database

[eluser]Nexus Rex[/eluser]
[quote author="PDP" date="1243232347"]

Code:

<select id="calendar_id" name="calendar_id" class="select small-column">
    &lt;?php foreach ($calendars as $calendar):?&gt;
    <option value="&lt;?php echo $calendar->calendars_id;?&gt;" &lt;?php echo ($calendar->calendars_id == $event->calendars_id) ? set_select('calendar_id', $event->calendars_id, TRUE) : set_select('calendar_id', $event->calendars_id); ?&gt; >&lt;?php echo $calendar->calendars_name;?&gt;</option>
    &lt;?php endforeach;?&gt;
</select>

This is what I do with simple selects. The logic works on check boxes and radio buttons.[/quote]

Brilliant!

I used your method for two radio boxes:

Code:

&lt;?php echo form_radio('active', '1', FALSE, (1 == $member->active) ? set_radio('active', $member->active, TRUE) : set_radio('active', '1')); ?&gt; <label for="active">Active</label>
&lt;?php echo form_radio('active', '0', FALSE, (0 == $member->active) ? set_radio('active', $member->active, TRUE) : set_radio('active', '0')); ?&gt; <label for="active">Inactive</label>