PHP SQL Pagination LIMIT clause

Question

i have problem in my sql query. my limit can not work properly. the displaying error is this. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT0, 10' at line 137 my function is this in which i call query

function getprofitinstructornoman($id,$start,$per_page)
{
     $select="select s.id,s.name,s.phone,s.email from smaccount s where s.manager_id='".$id."'LIMIT".$start.", ".$per_page;
        $res = $GLOBALS ['mysqli1']->query ($select) or die ($GLOBALS ['mysqli1']->error . __LINE__);
        if ($res->num_rows > 0)
        {return $res;}
        else{return false;}
}

please tell me where is the problem? and why my query is not working properly? thanks Mohsin

Adrian Lange · Accepted Answer · 2014-03-11 09:51:23Z

3

You are missing a space. Use this instead of your line of code.

$select="select s.id,s.name,s.phone,s.email from smaccount s
where s.manager_id='".$id."' LIMIT ".$start.", ".$per_page;

I've added an extra space before and after "LIMIT".

edited Mar 11, 2014 at 9:51

Adrian Lange

47813 silver badges18 bronze badges

answered Mar 11, 2014 at 9:45

Ulrich Thomas Gabor

6,6844 gold badges31 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP SQL Pagination LIMIT clause

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related