[SOLVED] mysql limit query

[daveh33]

$result = mysql_query("SELECT DISTINCT(number) FROM $tablename LIMIT $lp, 10000") or die(mysql_error());

 

this line of code produces error: -

 

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 ' 10000' at line 1

 

any ideas why?

[asmith]

echo it  , that's the thing i always do ,

you have some variables in that query ,  echo only the query (from "select...)

and see what it shows , then you'll find it .

[adam291086]

change to this

 

$result = mysql_query("SELECT DISTINCT(number) FROM $tablename LIMIT '$lp', 10000") or die(mysql_error());

[daveh33]

Thanks I updated to that line of code - the error changed slightly: -

 

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 ''0', 10000' at line 1