Greetings,

On my website, I display webcams (non-adult)from around the country. All my information for each webcam it stored in a database. I need help figuring out how to setup a search feature on my site. I want it to search the database, and display its results to the visitor.

How might I do this??

Thanks,
Richard

I found a search script that works with my setup. But, I need some help with an area of the querry.

I want to be able to search these cells in the wcdatabase table

country state city camname sdesc

and compare it to the search word. $trimmed.

This is the querry:

$query = "select * from wcdatabase where state like \"%$trimmed%\"
order by camname";


Now, the whole script works. I am able to search the database for the search term just fine. But, I am only able to search in one cell, and only one cell.

I want to be able to search the other cells also at the same time.

Thanks,
Richard