searching mysql with php

[Anon]

Hey there,
I am trying to find a script somewhere or be led in the right direction on how to have a search engine on my page using a mysql database. In the database I will have several links articles (into the 1,000s after some time) in one column, and id column, and a keyword column, where the keywords will be separated by a comma, or something, I don't really care what it is. Basically, I need to search the keywords and return the results to a html page so people can click on them and view the article. It seems pretty basic, but I'm not sure where to start. I know there must be a script out there somewhere that I can use so I don't have to make my own. If you can help, that'd be great. Thanks.

[calebsg]

Well, i dunno if this is the best way to do it, but I did this once.

First formulate your SQL query:
$query = "SELECT * FROM your_table WHERE 'keyword_column' LIKE '%$criteria_entered_in_search_box_in_your_form%')" or die("Error in query");

Then run a while loop such as:
while($myrow = mysql_fetch_array($result)) { //display results here }

and that should print it out.

Like I don't know if it's the best way, but it should get you started. I used this to search through keywords on a mp3 cataloguing database.

[Anon]

Hey, thanks. I'll definetly try that. It should work great.