All pastes #562082 Raw Edit

Stuff

public php v1 · immutable
·published 2007-06-12 18:04 UTC
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;