Jump to content


Photo

Searching A Database


  • Please log in to reply
2 replies to this topic

#1 markduce

markduce
  • Members
  • PipPip
  • Member
  • 22 posts

Posted 01 March 2006 - 02:31 PM

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

#2 oriental_express

oriental_express
  • Members
  • PipPipPip
  • Advanced Member
  • 113 posts

Posted 14 November 2007 - 02:14 AM

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 ?

#3 gin

gin
  • Members
  • PipPipPip
  • Advanced Member
  • 82 posts

Posted 14 November 2007 - 02:59 AM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users