<?
function getoptions()
{
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM gigFinder ORDER BY gigStart ASC";
$result=mysql_query($query);
$optionstr = "";
while($row=mysql_fetch_assoc($result))
{
extract ($row);
$optionstr .= "<option value='$rslt'>$rslt</option>\r\n";
}
return $optionstr;
} //end of function
$num=mysql_numrows($result);
mysql_close();
echo "";
?>
<?
$i=0;
while ($i < $num) {
$gigDay=mysql_result($result,$i,"gigDay");
$gigMonth=mysql_result($result,$i,"gigMonth");
$gigYear=mysql_result($result,$i,"gigYear");
$gigBandName=mysql_result($result,$i,"gigBandName");
$gigVenue=mysql_result($result,$i,"gigVenue");
$gigCountry=mysql_result($result,$i,"gigCountry");
$gigCounty=mysql_result($result,$i,"gigCounty");
$gigTown=mysql_result($result,$i,"gigTown");
$gigPlay=mysql_result($result,$i,"gigPlay");
$gigAdmission=mysql_result($result,$i,"gigAdmission");
$gigStart=mysql_result($result,$i,"gigStart");
$gigRestriction=mysql_result($result,$i,"gigRestriction");
$gigComment=mysql_result($result,$i,"gigComment");
$gigContactEmail=mysql_result($result,$i,"gigContactEmail");
$gigContactWeb=mysql_result($result,$i,"gigContactWeb");
$gigId=mysql_result($result,$i,"gigId");
?>
<HTML>
<HEAD>
<TITLE>gigBeHeard :: add gig ::
</TITLE>
</HEAD>
<BODY>
<form method="post" action="searchGig.php">
<br>Band Name: <select name="gigBandName">
<option></option>
<? = getoptions('gigBandName') ?>
</select>
<br>Band Play: <input type="text" name="gigPlay">
<br>Gig Date (dd:mm:yyyy):
<select name="gigDay">
<option></option>
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
<select>
:<select name="gigMonth">
<option></option>
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option></select>
:<select name="gigYear">
<option></option>
<option>2005</option>
<option>2006</option>
<option>2007</option>
<option>2008</option></select>
<br>Gig Venue: <input type="text" name="gigVenue">
<br>County: <input type="text" name="gigCounty">
<br>Country: <select name="gigCountry">
<option></option>
<option value="UK">United Kingdom
<option value="US">United States
<option value="CA">Canada
<option value="AF">Afganistan
<option value="AL">Albania
<option value="DZ">Algeria
<option value="AD">Andorra
<option value="AO">Angola
<option value="AI">Anguilla
<option value="AQ">Antarctica
<option value="AG">Antigua
<option value="AR">Argentina
<option value="AM">Armenia
<option value="AW">Aruba
<option value="AU">Australia
<option value="AT">Austria
<option value="AZ">Azerbaijan
<option value="BS">Bahamas
<option value="BH">Bahrain
<option value="BB">Barbados
<option value="BD">Bangladesh
<option value="BY">Belarous
<option value="BE">Belgium
<option value="BZ">Belize
<option value="BJ">Benin
<option value="BM">Bermuda
<option value="BT">Bhutan
<option value="BW">Botswana
<option value="BO">Bolivia
<option value="BA">Bosnia
<option value="BV">Bouvet Island
<option value="BR">Brazil
<option value="BN">Brunei Darussalam
<option value="BG">Bulgaria
<option value="BF">Burkina Faso
<option value="BI">Burundi
<option value="KH">Cambodia
<option value="CM">Cameroon
<option value="CV">Cape Verde
<option value="KY">Cayman Islands
<option value="CY">Central Aferican Republic
<option value="TD">Chad
<option value="CL">Chile
<option value="CN">China
<option value="CX">Christmas Island
<option value="CC">Cocos Islands
<option value="CO">Columbia
<option value="KM">Comoros
<option value="CG">Congo
<option value="CD">Congo, Democratic Republic
<option value="CK">Cook Islands
<option value="CR">Costa Rica
<option value="CI">Ivory Coast
<option value="HR">Croatia
<option value="CU">Cuba
<option value="CY">Cyprus
<option value="CZ">Czech Republic
<option value="DK">Denmark
<option value="DJ">Djibouti
<option value="DM">Dominica
<option value="DO">Dominican Republic
<option value="TP">East Timor
<option value="EC">Ecuador
<option value="EG">Egypt
<option value="SV">El Salvador
<option value="GQ">Equilateral Guinea
<option value="ER">Eritrea
<option value="EE">Estonia
<option value="ET">Ethiopia
<option value="FK">Falkland Islands
<option value="FO">Faroe Islands
<option value="FJ">Fiji
<option value="FI">Finland
<option value="FR">France
<option value="GF">French Guiana
<option value="PF">French Polynesia
<option value="MK">Macedonia
<option value="GA">Gabon
<option value="GM">Gambia
<option value="GE">Georgia
<option value="DE">Germany
<option value="GH">Ghana
<option value="GI">Gibralter
<option value="GB">Great Britain
<option value="GR">Greece
<option value="GL">Greenland
<option value="GD">Grenada
<option value="GP">Guadeloupe
<option value="GU">Guam
<option value="GT">Guatemala
<option value="GN">Guinea
<option value="GW">Guinea-Bissau
<option value="GY">Guyana
<option value="HT">Haiti
<option value="HN">Honduras
<option value="HK">Hong Kong
<option value="HU">Hungary
<option value="IS">Iceland
<option value="IN">India
<option value="ID">Indonesia
<option value="IR">Iran
<option value="IQ">Iraq
<option value="IE">Ireland
<option value="IL">Israel
<option value="IT">Italy
<option value="JM">Jamaica
<option value="JP">Japan
<option value="JO">Jordan
<option value="KZ">Kazakhstan
<option value="KE">Kenya
<option value="KI">Kiribati
<option value="KP">Korea, North
<option value="KR">Korea, South
<option value="KW">Kuwait
<option value="LA">Laos
<option value="LV">Lativa
<option value="LB">Lebanon
<option value="LR">Liberia
<option value="LY">Libya
<option value="LS">Lesotho
<option value="LT">Lithuania
<option value="LU">Luxembourg
<option value="MO">Macau
<option value="MG">Madagascar
<option value="MW">Malawi
<option value="MY">Malaysia
<option value="MV">Maidives
<option value="ML">Mali
<option value="MT">Malta
<option value="MH">Marshal Islands
<option value="MQ">Martinique
<option value="MR">Mauritania
<option value="MU">Mauritius
<option value="YT">Mayotte
<option value="MX">Mexico
<option value="FM">Micronesia
<option value="MC">Monaco
<option value="MD">Moldovia
<option value="MA">Morocco
<option value="MN">Mongolia
<option value="MS">Montserrat
<option value="MZ">Mozambique
<option value="MM">Myanmar
<option value="NA">Nambia
<option value="NR">Nauru
<option value="NP">Nepal
<option value="NL">Netherlands
<option value="AN">Netherlands Antillies
<option value="NC">New Calidonia
<option value="NZ">New Zealand
<option value="NI">Nicaragua
<option value="NE">Niger
<option value="NG">Nigeria
<option value="NU">Niue
<option value="NF">Norfold Island
<option value="MP">Northern Mariana Islands
<option value="NO">Norway
<option value="OM">Oman
<option value="PK">Pakistan
<option value="PW">Palau
<option value="PA">Panama
<option value="PG">Papau New Guinea
<option value="PY">Paraguay
<option value="PE">Peru
<option value="PH">Phillipines
<option value="PN">Pitcairn
<option value="PL">Poland
<option value="PT">Portugal
<option value="PR">Puerto Rico
<option value="QA">Qatar
<option value="RE">Reunion
<option value="RO">Romania
<option value="RU">Russian Federation
<option value="RW">Rwanda
<option value="GS">Sandwich Islands
<option value="KN">Saint Kitts
<option value="LC">Saint Lucia
<option value="VC">Saint Vincent
<option value="WS">Samoa
<option value="SM">San Marino
<option value="ST">Sao Tome
<option value="SA">Saudi Arabia
<option value="SN">Senegal
<option value="SC">Seychelles
<option value="SL">Sierra Leone
<option value="SG">Singapore
<option value="SI">Slovenia
<option value="SK">Slovak Republic
<option value="SB">Soloman Islands
<option value="SO">Somalia
<option value="ZA">South Africa
<option value="ES">Spain
<option value="LK">Sri Lanka
<option value="SH">St, Helena
<option value="SD">Sudan
<option value="SR">Suriname
<option value="SJ">Svalbard
<option value="SZ">Swaziland
<option value="SE">Sweden
<option value="CH">Switzerland
<option value="SY">Syria
<option value="TW">Taiwan
<option value="TJ">Tajikistan
<option value="TZ">Tanzania
<option value="TH">Thailand
<option value="TG">Togo
<option value="TK">Tokelau
<option value="TO">Tonga
<option value="TT">Trinidad
<option value="TN">Tunisia
<option value="TR">Turkey
<option value="TM">Turkmenistan
<option value="TC">Caicos Islands
<option value="TV">Tuvalu
<option value="UG">Uganda
<option value="UA">Ukraine
<option value="AE">United Arab Emirates
<option value="UM">US Minor Outlying Islands
<option value="UY">Uruguay
<option value="UZ">Uzbekistan
<option value="VU">Vanuatu
<option value="VA">Vatican City State
<option value="VE">Venezuela
<option value="VN">Viet Nam
<option value="VG">Virgin Islands (British)
<option value="VI">Virgin Islands (US)
<option value="WF">Wallis and Fortuna Islands
<option value="EH">West Sahara
<option value="YE">Yemen
<option value="YU">Yugoslavia
<option value="ZM">Zambia
<option value="ZW">Zimbabwe
</select>
<input type="submit" value="Search" name="Submit">
</form>
</BODY>
</HTML>