Welcome Guest, Not a member yet? Register   Sign In
combine like and get_where search statements
#18

[eluser]Philipp Datz[/eluser]
should say it is working now changed the query to
$sql = "SELECT * FROM `news` WHERE `title` LIKE '%$this->db->escape($query)%' AND `body` LIKE '%$this->db->escape($query)%' AND `published` = 1";

which has the variables in the string, nasty but works.
thanks you all again very much.

-philipp


Messages In This Thread
combine like and get_where search statements - by El Forum - 11-02-2008, 09:22 AM
combine like and get_where search statements - by El Forum - 11-02-2008, 09:53 AM
combine like and get_where search statements - by El Forum - 11-02-2008, 09:55 AM
combine like and get_where search statements - by El Forum - 11-02-2008, 10:15 AM
combine like and get_where search statements - by El Forum - 11-02-2008, 10:21 AM
combine like and get_where search statements - by El Forum - 11-02-2008, 10:24 AM
combine like and get_where search statements - by El Forum - 11-02-2008, 10:27 AM
combine like and get_where search statements - by El Forum - 11-02-2008, 10:32 AM
combine like and get_where search statements - by El Forum - 11-02-2008, 10:44 AM
combine like and get_where search statements - by El Forum - 11-02-2008, 11:24 AM
combine like and get_where search statements - by El Forum - 11-02-2008, 11:31 AM
combine like and get_where search statements - by El Forum - 11-02-2008, 11:45 AM
combine like and get_where search statements - by El Forum - 11-02-2008, 11:49 AM
combine like and get_where search statements - by El Forum - 11-02-2008, 11:59 AM
combine like and get_where search statements - by El Forum - 11-02-2008, 12:01 PM
combine like and get_where search statements - by El Forum - 11-02-2008, 12:24 PM
combine like and get_where search statements - by El Forum - 11-11-2008, 07:10 AM
combine like and get_where search statements - by El Forum - 11-11-2008, 07:27 AM



Theme © iAndrew 2016 - Forum software by © MyBB