Search a database

[________]

I got a website where all the content is stored in a mysql database... and I need to create a searchengine so that the users can find the right page.
Does any one got any ideas and tips?

[drag0n]

You have to do the form and also connect to db before this code.

$result = mysql_query ("SELECT * FROM tablename WHERE column LIKE '%$term%'");
$count = mysql_num_rows($result);
if($count == 0)
{
echo "Nothing found";
}
while($data=mysql_fetch_array($result))
{    

    $column=$data["column"];
    echo $column;
    echo "<br>";
}

[________]

okay... thanks... but what if the users try to search for more words - but enter them in a diffrent order then in the database?

[drag0n]

thats what the "like" is for 🙂