syntax error

[eluser]basicstudent[/eluser]

[eluser]WanWizard[/eluser]
How to fix what?

[eluser]basicstudent[/eluser]

[eluser]WanWizard[/eluser]
Then start by showing us some queries, this code doesn't contain any. How can we help if we don't know the error, and don't know the code?

If you have a syntax error, it shows you the query that failed, and what is wrong with it. So find the query (in your model?), and fix it?

[eluser]basicstudent[/eluser]

[eluser]mi6crazyheart[/eluser]
Can u show us your MODEL codes from where u r making those query... ?

[eluser]basicstudent[/eluser]

[eluser]WanWizard[/eluser]
That is not really a solution.

The query() method is used for hand-coded queries, which, unless you screened your parameters very carefully and properly escaped them all, just increased the chance on a sql injection.

Find the fault, and fix it. You still haven't shown us the code, or the query.

My educated guess is when $page = 0, your row indicator becomes negative (the -5). So it's a logic error you need to fix.

[eluser]basicstudent[/eluser]

[eluser]WanWizard[/eluser]
As I wrote earlier, if $page is zero,

Code:

$max = array($page_rows,($page - 1) * $page_rows);

will create an array

Code:

$max = array(5, -5);

Which in the model will be converted to

Code:

$this->db->limit(5, -5);

Which will cause a syntax error, limits may not be negative.