Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
nmotion
- Forum Commoner
- Posts: 32
- Joined: Wed Jan 22, 2003 6:53 am
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 ?
-
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.