dropdown box with search

[natman3]

I am seeking to create a page that has a drop down and depending on the drop down I choose allows me to search tables within my sql based on that chosen drop down. Similar to the one found at www.imdb.com but the drop down would be a list of the tables within the dba that the user could search. The purpose is to create a search box where an runn can enter in his name or bib number and select the year he wishes to view his resutls. The search would then look within the table of the year selected and display the runners info. I am not sure on how to accomplish this. If anyone knows of some resources that i can read or if anyone knows others who have done this and are willing to share knowlege I would be greateful

[Weedpacket]

It sounds like you've got separate tables for each year, which is an odd way of going about things.

[natman3]

I do have separate tables for each year. I have writen thus far this

<?php
					//print ($_POST['chooseTable']);
  				if(isset($_POST['upload']) && $_POST['chooseTable'] > 0)
				{

				$chooseT = $_POST['chooseTable'];
				if ($_POST['chooseTable'] != "none") 
				{


					// connection to dba
					$hostname_mydba = "localhost";
					$database_mydba = "ResultsDB";
					$username_mydba = "root";
					$password_mydba = "pw";
					$mydba = mysql_connect($hostname_mydba, $username_mydba, $password_mydba) or trigger_error(mysql_error(),E_USER_ERROR); 
					mysql_select_db($database_mydba);

					echo "selected";
				}

				else
				echo "failed to select";
			} 
			?>
<form name="form1" method="get" action="searchresult.php">								  

										<table width="130" border="0" cellpadding="0" cellspacing="0" class="searchBorder">
										<tr>
											<td class="title">Results look up</td>
										</tr>
									  		<td align="center" valign="top">
												<table border="0" cellpadding="0" cellspacing="0">
													<tr>
													<tr>
														<td align="right">First Name:</td>
														<td align="right"><input name="SearchString" type="text" id="SearchString" size="6"></td>
													</tr>
												</table>
											</td>
										<tr>
											<td align="left" valign="top">												
											 <select class="dropdownMedium" name="searchTable" id="searchTable">
												 <option selected value="none">-- Select Search Table --</option>
												 <?php setSearchTableName(); ?>
											   </select>
											   <input class="medium" type="hidden" name="TableName" value="<?php print(unFormatData($row[1])); ?>">
											</td> 
										</tr> 

									<tr>
										<td align="center">
										<table border="0" cellpadding="0" cellspacing="0">
											<tr>
												<td><input name="upload" type="submit" class="box" id="upload" value="Go"></td>
											</tr>
											</table>	
										</td>
									</tr>	
									</table>
							  		</form>

but am not sure how to tie in the drop down to select the table when the user submits the search

[leatherback]

Why do you have a table for each year? You preferably have one table, and a colum which defines the year.

[natman3]

Because I have defined a dba titled DBResutls within that dba I have structure there to be tables for each year which get populated with individual runner information pertaining to that year. The runner info consists of about 32 fields

[leatherback]

Yes. I understand that you have tables for each year. The question is: WHY.

The PROBLEM with this setuip is that you will have to edit your website for each year, adapt your queries, database, insert/update routines. So.. Everything. Whereas if you have one table, with a colum for yewar, you can build it now, and use it untill the unix_timestamp runs out of space.

J.