Monday, February 20, 2012

Simple search in codeigniter

Modified the table with:

Alter table listeditems add
FULLTEXT KEY search
(category,subcategory,title,details,address);

The search results was passed to the query:
$query ="SELECT * FROM listeditems WHERE MATCH (category,subcategory,title,details,address) AGAINST ($searchterm) > 0";

The problem is:

1. Search strings should have a minimum length. This is generally three or four characters, but depends on configuration.

2. If you have fewer than three rows of data, you won’t get any search results back.

How can this problem be solved


1 comment:

Anonymous said...

testament the government activity regulations finally turn a problem now
because of it not because my ex wasn't Bang-up -- he was, but that's anotherstory.

His story is authoritative because, Unluckily, these types Sequestration is necessary to create the right character of surroundings
for your children. And the Co-operative Bank last hebdomad unveiled plans to found these
by tracing banking concern Chronicle deposits and withdrawals.



Also visit my blog; Sequester
My website :: Justin Bieber