rendered paste body case 'search': $hlQuery = "SELECT t1.headline_id,t1.cat_id,t1.title,t1.active,t1.adddate,t2.cat_id,t2.name AS cat_name FROM ".TABLE_HEADLINES." t1, ".TABLE_HEADLINES_CAT." t2 WHERE t2.cat_id = t1.cat_id AND ("; $search = explode('%20', $_GET['s']); for($i = 0; $i < sizeof($search); $i++) { $hlQuery .= " `title` LIKE '%".$search[$i]."%' "; $hlQuery .= "OR"; $hlQuery .= " `text` LIKE '%".$search[$i]."%' "; $hlQuery .= "OR"; $hlQuery .= " `sourcename` LIKE '%".$search[$i]."%'"; $hlQuery .= ((sizeof($search) > 1) && ($i < sizeof($search)-1)) ? " OR" : ""; } $hlQuery .= " ) ORDER BY t1.adddate DESC"; $hlObj = data::tep_db_query($hlQuery); break;