[Resolved] searching into cells

[helil]

I'm learning PHP and MySQL following tutorials and foruns. Doing so, I managed to create a database of recipes, a dinamic page with all recipes names as links to dinamic generated pages of the clicked recipe.

But so far I could not make a form that would search the contents of the recipes to, for instance, list all recipes with "pepper". All I could do is search for the first word(s) of each cell.

Any help?

thanks

[jernhenrik]

What are you using to produce your results?? LIKE or ? Perhaps if you show some of the code you have made it would be easier to help you...else take a look at these pages where LIKE is described with wildcards and indekses.

http://www.mysql.com/doc/en/String_comparison_functions.html#IDX1206
http://www.mysql.com/doc/en/MySQL_indexes.html#IDX884
http://www.mysql.com/doc/en/MySQL_indexes.html#IDX885

hth

[helil]

Thanks for your answer, but I couldn't make that work.

The following worked fine (where "teste" is supplied by the user, via form, and "id, nome, ing, modo, extras" are columns names):

$query =
"SELECT * FROM receitas WHERE nome LIKE ('%$teste%')";

$result = mysql_query($query);
$number = mysql_numrows($result);

if ($number == 0) {print "Sorry";} else {
print "<br>There is $number recipes<br>";
for ($i=0; $i<$number; $i++) {
$nome = mysql_result($result,$i,"nome");
print "$nome<br>";
}
}

---

But I couldn't make the query work in more than one column. I tried this:

$query =
"SELECT * FROM receitas WHERE nome, modo LIKE ('%$teste%')";

It pointed an error on this line:

$number = mysql_numrows($result);

---

Besides, I read in the MySQL Manual that I should use MATCH/AGAINST, but again, I couldn't use it.

Thanks again,
helil

[bastien]

if the structure has a field called ingredients (which holds a list of stuff to put in the dish, i know what a surprise😃 ) you caould then search just the one field for the item....

i think that structure here is more of an issue than coding to search the tables for a match.

[helil]

Here's the structure of "receitas" table:

Field |Type |Attributes| Null |Default|Extra

id |tinyint(4) | | No | |auto_increment

nome |varchar(30)| | No | |

ing |text | | No | |

modo |text | | No | |

extras|text | | No | |

Keyname | Unique | Field
id | Yes | id

As I am doing this table and pages for learning, yes, I could just search de "ing" column, but I wanted to know wether it is possible to search all fields.

Thanks,

helil

[edwardsbc]

You can only use one field name per comparison in SQL! Try this:

$query =
"SELECT * FROM receitas WHERE nome LIKE ('%$teste%') OR modo LIKE ('%$teste%')";

[helil]

Thanks a lot, it's perfect!

helil