Oh, just to throw this in-MySql has a built-in search "help"
<?
$input = 'blue fox';
$query = mysql_query("SELECT * FROM `table`WHERE `column` LIKE '%$input%'");
while($show = mysql_fetch_assoc($query)) {
echo $show['column'] . "<br .";
}
?>
Of course, you'd want to check if there is anything returned. use mysql_num_rows(); for that. If the value of that equals != 0, then you're good. else { return an error message }.
Last edited by Andrieux; Feb 9th, 2009 at 6:32 pm.
Reputation Points: 10
Solved Threads: 4
Junior Poster in Training
Offline 60 posts
since Jan 2009