Lines Matching refs:where
283 $where = 'WHERE blog = ' . $db->quote_string($query['blog']) . ' ';
285 $where = 'WHERE blog != "" ';
291 $where .= 'AND ( title LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
294 $where .= 'AND ( author LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
297 … $where .= 'AND ( comments.text LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
300 … $where .= 'AND ( comments.ip LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
303 … $where .= 'AND ( tags.tag LIKE \'%'.$db->escape_string($query['string']).'%\' ) ';
310 $where .= 'AND ( comments.pid = ' . $db->quote_string($query['pid']) . ' ) ';
313 $sqlcount = $count . $from . $where;
314 $sqlselect = $select . $from . $where . $orderby;
496 $where = 'WHERE blog != "" ';
500 $where = '';
506 $sqlcount = $count . $from . $where;
507 $sqlselect = $select . $from . $where . $orderby;