Hello!
I am using Mysql 3.23.51.
I am running this query:
$sql=mysql_query("SELECT PCatID,PPSID,CatURL,LEFT(CatText,$LinkTextLen)AS CatText,CatX,LEFT(CatDescription,$LinkDescLen)AS CatDescription FROM $table_ppscategory WHERE PCatID='$CatID' ".
"ORDER BY CatX DESC LIMIT $vstart1, $vend1 ",$db);
When $vstart1=0 and $vend1=10 I really get 10 results.
But when $vstart1=10 and $vend1=20 I get 15! results (instead of 10!).
Is there something wrong in my query, or is it a bug of the mysql database?
thanks