php search mysql database

[suckerr70]

I have made a posting script in php that works with mysql. I have a few pages that calls for posts depending on the category. If you click the food category link, it will only show stuff from posts with food as the category.

 

Now, I would also like people to be able to search my database for posts and display them. How would I go about doing that? I don't even know where to start. Thanks.

[drummer101]

<? echo "<a href=\"page.php?food=apples\">"; ?>
<? 
$item = $_GET['food'];

$sql = mysql_query(SELECT * FROM your_table WHERE your_table.food = '$item'");

while ($r = mysql_fetch_array($sql)){
    echo $r['food_item'];
}
?>

[suckerr70]

I don't really get that script. Can you explain it please? Also, I need the search to search multiple thing like: title, catagory, description.

[drummer101]

<?

echo "<form name=\"search\" method=\"post\">";
echo "<select name=\"search_by\">";
echo "<option value=\"title\">Title</option>";
echo "<option value=\"category\">Category</option>";
echo "<option value=\"description\">Description</option>";
echo "</select>";
echo "<input type=\"text\" name=\"search\">";

@$search_by = $_POST['search_by'];
@$search = $_POST['search'];

$sql = mysql_query("SELECT * FROM <your table> WHERE $seach_by LIKE %'$seach'%");
?>

 

 

[Northern Flame]

here are 2 examples of how to create a search script,

the one I posted is a bot more complex, and the

one posted by the other person is more simple:

 

http://www.phpfreaks.com/forums/index.php/topic,174411.msg771490.html