PHP select issue

[queensgambit9]

Hi

I display 20 rows per page. When going to next page and perform a search the SQL Query will be:

Code: [Select]

SELECT * FROM [table] where id like CONCAT('%', '123', '%') LIMIT 20, 20;
This will give 0 rows returned if there is less than 20 rows returned (1 for example)...how can I address this?

[paramvir]

[ Only Pro members may read this post. ]

[queensgambit9]

Thanks, had some error in my PHP for getting data.