Searching Database

[Shit4Brains]

I got this...

$result = mysql_query("SELECT * FROM qst_logbook WHERE $search_where LIKE '%$search_keyword%' ORDER BY `log_id` ASC",$db) or die("Error Executing Query");

works nicely for searching a field which i know. But i want $search_where to also have the option of 'Anywhere' so the db looks in all fields of the row to try and find what is specified...

how would i do that?

i thort maybe:

$result = mysql_query("SELECT * FROM qst_logbook WHERE %% LIKE '%$search_keyword%' ORDER BY `log_id` ASC",$db) or die("Error Executing Query");

[AstroTeg]

To look in all fields, you'd have to specify each one in the WHERE statement. Something like: WHERE field1 LIKE '%$search_keyword%' OR field2 LIKE '%$search_keyword%' OR field3 LIKE '%$search_keyword%'

[Shit4Brains]

ah poo, i got lots of fields! long sql query here we go! .....