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

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members