with mysql limiting results and setting up next and prev pages is a snap (more or less)
Im currently trying to connect to an old cobol based database via odbc.
so far all works and I can get results and row counts.
I can't however get any sort of limiting on the number of returned rows.
LIMIT is not supported, nor is TOP or any other means I can think of.
the driver is odbc 2.0 compliant but I have limited knowlege of the version specific syntax.
any suggestions for something that would approximate
$result = mysql_query("$sql limit $page,$limit");
would be greatly appreciated.