Searching A Database
Posted 01 March 2006 - 02:31 PM
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
Posted 14 November 2007 - 02:14 AM
Posted 14 November 2007 - 02:59 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users