Move next in MySql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
nmotion
Forum Commoner
Posts: 32
Joined: Wed Jan 22, 2003 6:53 am

Move next in MySql

Post by nmotion »

In ASP and MS SQL you can use move next to skip a number of records before looping trough them. How do you do this in PHP and MySQL ?
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post by m3mn0n »

LIMIT 10, 20


..maybe?
McGruff
DevNet Master
Posts: 2893
Joined: Thu Jan 30, 2003 8:26 pm
Location: Glasgow, Scotland

Post by McGruff »

Another option might be mysql_data_seek() - but LIMIT'ing the result in the first place might be best.
Post Reply