I'm interested in the limit parameter. When ever I try to use that I get this 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 '(0,5)' at line 5"
this is the line in question:
ORDER BY table.smth ASC LIMIT (0,5)";
It's part of a query that works perfectly if I remove the limit parameter so the errore can only be here.
In some examples I have seen it used like :
ORDER BY table.smth ASC LIMIT 0,5";
or
ORDER BY table.smth ASC LIMIT 5";
But all will output the same error for me... I need the limit in order to split my query results in multyple pages... I'm folowing this tutorial BTW:
http://www.php-mysql-tutorial.com/php-mysql-paging.php
But the limit parameter just won't work for me... can anybody help please?