searching database for text

[Anon]

hi!

I am quit new to mysql so sorry for this basic question.

I want to search a table in a database for a word entered in a form on a webpage.

What I have is the the form sending me a string to the database via php -> now how do I search a certain table for this text string and get all entries in this table which include the string?

thanks for you help

regards

michael

[znouza]

try:
$find="sometext";
mysql_connect($db,$username,$pass);
$result=mysql_query("select field from table where field like '%$find%'");
if (mysql_num_rows($result)) {
for($i=0;$i<mysql_num_rows($result);$i++)
echo mysql_result($result,$i,"field")."<br>";
}
mysql_close();

and I recommend to see at SELECT and LIKE statement from MySQL manual