populate name dump down database table
i have list ("venues") stores illusory venues invitation work, any invitation indifferent work venue each.
i wish emanate name dump down venues table.
right i arrangement venue any invitation assigned, nonetheless i wish arrangement dump down box, venue already comparison list.
<form action="upd.php?id=7">
<select name="venue_id">
<?php //some arrange loop goes here
print '<option value="'.$row['venue_id'].'">'.$row['venue_name'].'</option>';
//end loop here ?>
</select>
<input type="submit" value="submit" name="submit">
</form>
for example, invitation id 7, indifferent venue_id 4
<form action="upd.php?id=7">
<select name="venue_id">
<option value="1">bagpipe competition</option>
<option value="2">band assistance</option>
<option value="3">beer/wine pouring</option>
<option value="4" selected>brochure distribution</option>
<option value="5">childrens area</option>
<option value="6">cleanup</option>
<option value="7">cultural core display</option>
<option value="8">festival merch</option>
</select>
<input type="submit" value="submit" name="submit">
</form>
brochure chain choice already comparison displays dump down list, since volunteers_2009 table, buttress venue_id 4.
i know take form while loop lift list venues venues table
my query is:
$query = "select volunteers_2009.id, volunteers_2009.comments, volunteers_2009.choice1, volunteers_2009.choice2, volunteers_2009.choice3, volunteers_2009.lname, volunteers_2009.fname, volunteers_2009.venue_id, venues.venue_name volunteers_2009 volunteers_2009 left outdoor join venues (volunteers_2009.venue_id = venues.id) method $order $sort";
how i stock name dump down box venues (volunteers_2009.venue_id, venues.id) venues list have pre-select venue list?
Comments
Post a Comment