Jump to content

Not Loading Arenas


Xtremer360

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.