Can anyone tell me what is wrong with the code that is below? Whenever I use this it
returns all the records in the table no matter what is searched for.
Thanks for any help,
Terry
---------- CODE ------------
<?
if ($submit) {
// DB Connect
$db=mysql_connect("localhost","username","password"); // Changed for php list
mysql_select_db("Database"); // Changed for php list
$query = "SELECT * FROM Players WHERE Player LIKE '%$player_nameA%' OR Player LIKE
'%$player_nameB%' OR College LIKE '%$college%' OR Draft_Year LIKE '%$year_drafted%' OR
Round_Drafted LIKE '%$round_drafted%' OR Position LIKE '%$position%' OR
Years_Team_Search LIKE '%$year_team%' OR Uniform_Number LIKE '%$uniform%' ORDER BY
Player_ID";
$result = mysql_query($query);
if(!$result) echo "No Results";
if($myrow=mysql_fetch_array($result)) {
echo "<br><b>Search results:</b><br>";
echo "<ol>";
do {
echo "<li>".$myrow["Player"]."";
} while ($myrow=mysql_fetch_array($result)); // start loop over to output more because
$myrow was set again
echo "</ol><br>";
?>
--------- END CODE ----------
----------- FORM ------------
<table>
<form method="post" action="players.php">
<tr>
<td>
Players First Name</td><td><input type="text" size="20" name="player_nameA" />
</td>
</tr>
<tr>
<td>
Players Last Name</td><td><input type="text" size="20" name="player_nameB" />
</td>
</tr>
<tr>
<td>
College</td><td><input type="text" size="20" name="college" />
</td>
</tr>
<tr>
<td>
Year Drafted </td><td><select name="year_drafted">
<option value="">Any</option>
<option value="1968">1968</option>
<option value="1969">1969</option>
<option value="1970">1970</option>
<option value="1971">1971</option>
<option value="1972">1972</option>
<option value="1973">1973</option>
<option value="1974">1974</option>
<option value="1975">1975</option>
<option value="1976">1976</option>
<option value="1977">1977</option>
<option value="1978">1978</option>
<option value="1979">1979</option>
<option value="1980">1980</option>
<option value="1981">1981</option>
<option value="1982">1982</option>
<option value="1983">1983</option>
<option value="1984">1984</option>
<option value="1985">1985</option>
<option value="1986">1986</option>
<option value="1987">1987</option>
<option value="1988">1988</option>
<option value="1989">1989</option>
<option value="1990">1990</option>
<option value="1991">1991</option>
<option value="1992">1992</option>
<option value="1993">1993</option>
<option value="1994">1994</option>
<option value="1995">1995</option>
<option value="1996">1996</option>
<option value="1997">1997</option>
<option value="1998">1998</option>
<option value="1999">1999</option>
<option value="2000">2000</option>
<option value="2001">2001</option>
<option value="2002">2002</option>
</select></td>
</tr>
<tr>
<td>
Round Drafted </td><td><input type="text" size="20" name="round_drafted" />
</td>
</tr>
<tr>
<td>
Position</td><td><select name="position">
<option value="">Any</option>
<option value="offense">Offense</option>
<option value="defense">Defense</option>
<option value="special_teams">Special Teams</option>
</select>
</td>
</tr>
<tr>
<td>
Year With the team</td><td><select name="year_team">
<option value="">Any</option>
<option value="1968">1968</option>
<option value="1969">1969</option>
<option value="1970">1970</option>
<option value="1971">1971</option>
<option value="1972">1972</option>
<option value="1973">1973</option>
<option value="1974">1974</option>
<option value="1975">1975</option>
<option value="1976">1976</option>
<option value="1977">1977</option>
<option value="1978">1978</option>
<option value="1979">1979</option>
<option value="1980">1980</option>
<option value="1981">1981</option>
<option value="1982">1982</option>
<option value="1983">1983</option>
<option value="1984">1984</option>
<option value="1985">1985</option>
<option value="1986">1986</option>
<option value="1987">1987</option>
<option value="1988">1988</option>
<option value="1989">1989</option>
<option value="1990">1990</option>
<option value="1991">1991</option>
<option value="1992">1992</option>
<option value="1993">1993</option>
<option value="1994">1994</option>
<option value="1995">1995</option>
<option value="1996">1996</option>
<option value="1997">1997</option>
<option value="1998">1998</option>
<option value="1999">1999</option>
<option value="2000">2000</option>
<option value="2001">2001</option>
<option value="2002">2002</option>
</select>
</td>
</tr>
<tr>
<td>
Uniform Number</td><td><input type="text" size="20" name="uniform" />
</td>
</tr>
<tr>
<td colspan="2">
<center><input type="submit" name="submit" value="Search"></center>
</td>
</tr>
</table>
