search query

[eluser]r0mel[/eluser]
hi everyone, just one to ask if you some idea about text search using query in php sample:


->query

Code:

$this->db->query("select * from SEARCH where title like '%hows%'");

problem: the query above doesn't produce anything because what is in the table is how,,
do you any idea about that?




SEARCH TABLE
id title
1 how
2 know

[eluser]Otemu[/eluser]
The syntax looks correct however try this

Code:

$this->db->query("SELECT * FROM SEARCH where title LIKE '%how%'");

also your searching for hows and not how which could be the problem

Also check the query within MySQL/phpMyAdmin and see if it returns any results