Hi Antonio, > I need help for prompt LIMIT with two values, the > first value is the starting row, the second value > end of LIMIT.
I think your syntax is a little bit out... if you're passing two values, the following apply: - The first value is the starting row - The second value is the number of records to return So if you wanted to return rows 40 to 60, use "LIMIT 40,20" (start at 40 and return 20 rows from there) It's all explained on the SELECT man page: http://www.mysql.com/doc/en/SELECT.html (scroll down) HTH Jon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
