Hello,

I have problem in doing my search script,

I want to search more than one field in same table but with just one text box.

Does anyone here know how I can perform this search?

And if search result were so bit how can I slit the result to pages.

Thanks

just add another field named 'keyword' with your existing fields, which will contain the keywords for that column. this is the easiest way to solve your problem if i understand it properly.

SELECT *, MATCH (field1, field2) AGAINST ("keyword") AS score FROM table_name WHERE MATCH (field1, field2) AGAINST ("keyword") ORDER BY score DESC

This works efficiently if the fields to be matched are fulltext indexed