Using forms to Query Multiple names

[jj415]

I am trying to develope a dynamic website. I am using MySQL and PHP to do so. PLEASE HELP!!!!!!!!!!:confused:

PROBLEM: I need to create a form that will allow my users to query information using a php form. I have wrote one that works. Although it only allows my users to search 1 name at a time (one name meaning "first, middle, last). My users need to be able to search for a minimum of 30 and a maximum of 70 names at one time.

CODE:


<form action="form4.php" method="POST">
<table border=0 cellspacing=0 cellpadding=3>
<td> <tr colspan= 3 allign=center>
<h3> Input names to Search </h3>
<td>
Last Name
<td>
First Name
<td>
Middle Name
</table>
<input type="text" name="lastnameform">
<input type="text" name="firstnameform">
<input type="text" name="middlenameform">

<p>

<input type="submit" name= "submitbutt" value="get data">



<?php

include ('connect.php');

$dbname = "movedb";
mysql_select_db($dbname);

$lastnamesql = $_POST ['lastnameform'];
$firstnamesql = $_POST ['firstnameform'];
$middlenamesql = $_POST ['middlenameform'];

if (!$lastnamesql) {
die (mysql_error()); }
if (!$firstnamesql){
die (mysql_error()); }
if (!$middlenamesql) {
die (mysql_error()); }

$sql = mysql_query ("SELECT * FROM lacontribinfo WHERE lastname = '$lastnamesql' AND firstname='$firstnamesql' AND middlename = '$middlenamesql' ");

if (!$sql) {
die('<p>Error retrieving database!<br />'.
'Error: ' . mysql_error() . '</p>');
}
while ($row = mysql_fetch_assoc ($sql)) {
print "<h4>". "Results returned". "</h4>";
print "<table border=1>";


print "<td>" . "Last Name" . "<td>";
print "First Name" ."<td>";
print "Middle Name" . "<td>";
print "Committee Name"."<td>";
print "<tr>" ;
print "<td>" .$row['lastname'];
print "<td>".$row['firstname'];
print "<td>".$row['middlename'];
print "<td>".$row['committeename'];



print "</table>";

}

?>