combine like and get_where search statements

[eluser]Randy Casburn[/eluser]
OK... :red:

My query analyzer strips um...you are correct my friend, I've made a mistake. (damn it! But I know you'll go rejoice with your merry band of positive well wishers)

@Philipp - Sorry for misleading you with an inaccurate query. My friend Developer13 has discovered an error that I've made. Please change the query to:

Code:

$sql = "SELECT * FROM news
         WHERE title LIKE '%{$this->db->escape($query)}%'
         AND body LIKE '%{$this->db->escape($query)}%'
         AND published = 1"

@Develper13 - thanks for the help.

Randy