Re: MySQL Search problem

>> $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" I think the problem was occured when one of your criteria is empty. It makes all records will dislayed. If criteria is "%%" all records will displayed. Suggestion : ............. if ($player_nameA) $query = "OR Player LIKE '%$player_nameA%' "; if ($player_nameB) $query .= "OR Player LIKE '%$player_nameB%' "; if ($college) $query .= "OR College LIKE '%$college%' "; if ($year_drafted) $query .= "OR Draft_Year LIKE '%$year_drafted%' "; if ($round_drafted) $query .= "OR Round_Drafted LIKE '%$round_drafted%' "; if ($position) $query .= "OR Position LIKE '%$postition%' "; if ($year_team) $query .= "OR Year_Team_Search LIKE '%$year_team%' "; if ($uniform) $query .= "OR Uniform_Number LIKE '%$uniform%' "; $query = substr($query,3); // strip first OR. $query = "SELECT * FROM Players WHERE $query ORDER BY Player_ID"; ......... deZayner