[Zaiaku]

My girlfriend and her friends wanted to make a small database full of recipies. I got the program FormsToGo, made up a simple form page and everything went great. All recipies are submited to the database with no problems. Well now the entries are really getting way too long to display at once. So I want to make it to where they can search for certain ones by ingredients.

The database is as follows
-Recipies
---Ingredients
---CookingTime
---Difficulty
---Feeds

I need to search by keywords in ingrediants and have an output of just those recipies. Can someone help me out please.

[alej469]

A simple search query would be:

Code:

$query= "SELECT * FROM Recipies WHERE Ingredients LIKE '%ingredient_name_here%'";

$result=mysql_query($query);

[Zaiaku]

This is base of the search code I have now. No php errors but no results are being displayed. The file name is search.php.

PHP Code:

<form action="search.php" method="post">
<INPUT NAME="search" TYPE="text" VALUE="Keywords..." SIZE="33" MAXLENGTH="50">
</form>
<?
    $query= "SELECT * FROM Recipies WHERE Ingredients LIKE 'search'";
    $result=mysql_query($query);
    while ( $row = mysql_fetch_array($result) ) {
?>
<tr>
<td><? echo $row['Dish']; ?></td>
<td><? echo $row['Ingredients']; ?></td>
</tr>
<?
  }
?>

[Nico]

Try:

PHP Code:

$query= "SELECT * FROM Recipies WHERE Ingredients LIKE '%". mysql_real_escape_string($_POST['search']) ."%'"; 

[Zaiaku]

Thanks that worked perfectly

[Nico]

Replace this:

PHP Code:

$result=mysql_query($query); 

with this:

PHP Code:

$result=mysql_query($query) OR die( mysql_error() ); 

And are you sure Recipies shouldn't be Recipes?

[Zaiaku]

well it should be but I made a typo setting everything up.

[Nico]

Okay... so do you get any errors after the change?

[Zaiaku]

No errors what so ever. It works perfectly. Thank you so much. Althought the results are from oldest to newest. Is there a way to make the results list from last added to oldest?

[Zaiaku]

Nevermind I got the it ordering perfectly.