This topic is locked

Limit No Of Row Not Work

3/15/2013 12:21:44 AM
PHPRunner General questions
C
chanpeter88 author

I am using phprunner 6.1
In Query-> sql

... WHERE (s.create_date >= curdate() - interval 1 month)

ORDER BY s.ID DESC limit 100
I added limit 100 and build the project, but not work.

In ...setting.php file, limit 100 is omitted automatically. $tstrOrderBy = "ORDER BY s.ID DESC";

Sergey Kornilov admin 3/15/2013

PHPRunner adds LIMIT clause on it's own meaning you should not add it to the SQL query.