MySQL Search problem
| From: | Terry Huffman | Date: | Thu, 11 Apr 2002 07:01:32 +0000 |
| Subject: | MySQL Search problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18415@lists.php.net to get a copy of this message | ||
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>