Jump to content

Archived

This topic is now archived and is closed to further replies.

markduce

Searching A Database

Recommended Posts

Hi guys,

Heres the situation, my client wants a search facility on the site. I can do this OK, but the problem that I am finding is that as I am searching a database, I have to type every single field in.

eg "SELECT * FROM table WHERE name LIKE '%$search%' OR comment LIKE '%$search%'";

However, there are 25 fields on this table, and many more thousands on the other tables, so is it possible to search a row rather than a specific column?

Thanks in advance

Mark

Share this post


Link to post
Share on other sites
would be great if someone aswered this as i need to produce a search box that will search the whole table that has 11 attributtes. Is it possible to produce a search box that searches every column and every row ?

Share this post


Link to post
Share on other sites
The way I'd do it is to place all the fields into an array, then use a foreach to generate the query. I don't know if there's a way to seach rows like what you suggest.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.