Xtremer360 Posted November 30, 2009 Share Posted November 30, 2009 I can't get it to load the arenas. It's showing the countries correctly however when I select a country from the dropdown list it doesn't show anything in the arenas dropdown list. <?php { print '<script language="JavaScript" src="ts_picker.js"></script>'; print '<h1 class=backstage>Show Booking Management</h1><br />'; print '<table width="100%" class="table2">'; print '<tr>'; print '<td width="150" valign="center" class="rowheading">Show Name:</td>'; print '<td class="row3"><select name="show class="dropdown">'; print '<option value="0">- Select -</option>'; $query = "SELECT * FROM efed_list_shownames"; $result = mysql_query ( $query ); while ( $row = mysql_fetch_assoc ( $result ) ) { print "<option value=\"".$row['name']."\">".$row['name']."</option>\r"; } print '</select></td>'; print '<td class="row3" width="180"><span class="reduced">Set up in show Name Manager</span></td>'; print '</tr>'; print '<tr>'; print '<td width="150" valign="center" class="rowheading">Label:</td>'; print '<td class="row3"><input type="text" name="label" class="fieldtext40"></td>'; print '<td class="row3" width="180"><span class="reduced">e.g. Consecutive Number, Date</span></td>'; print '</tr>'; print '<tr>'; print '<td width="150" valign="center" class="rowheading">Air Date</td>'; print '<td class="row3"><input type="text" name="bookingdate" class="fieldtext80" value=""><a href="java script:show_calendar(document.showbooker.bookingdate, document.showbooker.bookingdate.value);"><img src="cal.gif" width="16" height="16" border="0" alt="Click Here to Pick the date"></a></td>'; print '<td class="row3"><span class="reduced">dd-mm-yyyy</span></td>'; print '</tr>'; print '<tr>'; print '<td class="rowheading" width="150" valign="center" class="rowheading">No. of Matches:</td>'; print '<td class="row3"><input type="text" name="numberofmatches" class="fieldtext40"></td>'; print '<td class="row3"><span class="reduced">More can be added later</span></td>'; print '</tr>'; print '<tr>'; print '<td class="rowheading">Country</td>'; print '<td class="row3" colspan="2"><select name="countryid" class="dropdown" onchange="ajaxpage("backstageajax.php?random=625094862&routine=arenas&countryid="+showbooker.countryid.value,"arenaajax");"><option value=0>- Select -</option>'; $query = 'SELECT * FROM efed_list_arenas_countries ORDER BY `country`'; $result = mysql_query ( $query ); while ( $row = mysql_fetch_assoc ( $result ) ) { print "<option value=\"".$row['country']."\">".$row['country']."</option>\r"; } print '</select></td>'; print '</tr>'; print '<tr>'; print '<td class="rowheading">Arena</td>'; print '<td class="row3" colspan="2"><div id="arenaajax"><select name="arenaid" class="dropdown"><option value="0">- Select Arena -</select><input type="hidden" name="location" value="0"></div></td>'; print '</tr>'; print '</table><br />'; print '<input type="submit" value="Add Booking" class="button"><br /><br />'; print '<input type="button" value="Return to Booking Manager" class="button200"><br /><br />'; print '<h2 class="backstage"><input type="button" value="Return to Main Menu" class="button200"></form></h2>'; } ?> case "arenas": print "<select name=arenaid class=dropdown><option value=0>- Select -"; $query = "SELECT ela.id as getarenaid, ela.city as getarenacity, ela.arena as getarenaname, ela.capacity as getcapacity FROM efed_list_arenas as ela WHERE ela.country_id = '$countryid' ORDER BY ela.arena"; $result = mysql_query ($query); while ($row = mysql_fetch_assoc($result)) { $fieldarray=array('getarenaid','getarenacity','getarenaname','getcapacity'); foreach ($fieldarray as $fieldlabel) { if (isset($row[$fieldlabel])) { $$fieldlabel=$row[$fieldlabel]; $$fieldlabel=htmlentities($$fieldlabel); } } print "<option value=\"".$getarenaid."\">".$getarenaname." - ".$getarenacity; } print "</select>\n"; break; Link to comment https://forums.phpfreaks.com/topic/183475-not-loading-arenas/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.