searching

natman3

I am seeking to create a search box that will look at the fields for a certin individuals records and pull the other related fields accordingly. I thought to have the user first query the dba with his name and number the from there the rest of the information would be linked to him. Basical i am wanting the person who enters in the name and number to beable to view his relative information. The name and number are 2 of the 21 fields that I want to have displayed when. but iam using the name and number for a way to get the inforamtion partaning to that person. I am looking for help in this area I am finding it difficult to get information on creating a search box that uses the info recieved and goes to the dba to compare for a match if match found i want the values or rather fields to be displayed. So far this is all I have.

<?php
if(isset($POST['find']) && ($POST['FirstName']) && ($_POST['BibNo']))
{

						$Firstname = $_POST['FirstName']; 
						$BibNo = $_POST['BibNo']; 

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

						$result = "SELECT * FROM ResultsDB WHERE FirstName = '$FirstName' AND BibNo = $BibNo";

						print "<table border=1>"; // start the table 
						$topRow = mysql_fetch_row($result);
						echo "<td bgcolor='cccccc'>" .$topRow[0]. "</td>";
						echo "<td bgcolor='cccccc'>" .$topRow[1]. "</td>";
						echo "<td bgcolor='cccccc'>" .$topRow[2]. "</td>";
						echo "<td bgcolor='cccccc'>" .$topRow[3]. "</td>";
						echo "<td bgcolor='cccccc'>" .$topRow[4]. "</td>";
						echo "<td bgcolor='cccccc'>" .$topRow[5]. "</td>";
						echo "<td bgcolor='cccccc'>" .$topRow[6]. "</td>";
						echo "<td bgcolor='cccccc'>" .$topRow[7]. "</td>";
						echo "<td bgcolor='cccccc'>" .$topRow[8]. "</td>";

						while ($row = mysql_fetch_array($result)) 
						{ 
						//this loops for as many records as the query finds 
						echo "<tr>"; 
						echo "<td>".$row[0]."</td>"; // 1st colum from db 
						echo "<td>".$row[1]."</td>"; // 2nd colum from db 
						echo "<td>".$row[2]."</td>"; // 3rd colum from db 
						echo "<td>".$row[3]."</td>"; // 4th colum from db 
						echo "<td>".$row[4]."</td>"; // 4th colum from db 
						echo "<td>".$row[5]."</td>"; // 5th colum from db 
						echo "<td>".$row[6]."</td>"; // 6th colum from db 
						echo "<td>".$row[7]."</td>"; // 7th colum from db
						echo "<td>".$row[8]."</td>"; // 8th colum from db
						echo "</tr>"; 
						}
						echo "</table>"; // Finish table. 





					}
					else
					echo "Please enter in both First Name and Bib No.";
					?>
						 <table width="130">
							<tr>

								<td><form name="search" id="search" method="post" action="<?php echo($PHP_SELF) ?>"> 									  
									<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">
									  	<br/>
										<br/>			

											<table border="0" cellpadding="0" cellspacing="0">
											<tr>
												<td align="right">First Name:</td>
												<td align="left"><input size="6" type="text" name="FirstName" id="FirstName"></td>

											</tr>
												<td align="right">Bib No:</td>
												<td align="left"><input size="6" type="text" name="BibNo" id="BibNo"></td>
											</tr>
											</table>

											<table border="0" cellpadding="0" cellspacing="0">
											<tr>
												<td><input name="find" type="submit" id="find" class="button" value="Go"></td>
											</tr>
											</table>										  
											<br/>
											<br/>
											<br/>
										  </td>
									</table>
							  		</form>
								</td>
							</tr>
						</table>

nemonoman

You have 1 bug:

$result = "SELECT * FROM ResultsDB...

You need to send this queyr to the db-- code needs to be:

$result =mysql_query("SELECT * FROM ...etc, etc., etc");

Now the result will contain a mysql resource. Now

$row=mysql_fetch_array($result)

Will work.

Your code looks like it otherwise might work, but I think it might prove a little buggy. It will certainly improve while you work on it.

I have never seen anybody try to fetch rows from the same result using two different methods:

$topRow = mysql_fetch_row($result);
$row = mysql_fetch_array($result)

I don't know how this will work:
my guess is that this will return unwanted results: i.e, results of first returned row will be found in $toprow, results of rows 2...n will be found in $row. IF there is only one row, returned (likely) then you will never find values in $row...at least that's my guess.

Also, why are you using two variables for a db search? Typically you would search based on one unique identifier:

db generated id

OR
phone number

OR
social security number

OR
email address

etc.

As you no doubt know, users who enter a valid number with a misspelled name will in your code return no values
.

natman3

thank you for the help.