Home » Open Source » Programming Interfaces » NUMROWS problem (in PHP)
NUMROWS problem (in PHP) [message #13914] Mon, 02 August 2004 11:19 Go to next message
ally
Messages: 6
Registered: November 2003
Junior Member
Hi,

I'm trying to use NUMROWS like you would use LIMIT in MySQL (the environment I'm coming from) and have a few problems.

WHERE ROWNUM <= 10

Does a good job of getting the first 10 records. However,

WHERE ROWNUM BETWEEN 10 and 20

Does not get 10-20, it returns nothing, the same happens with

WHERE ROWNUM >= 10 AND ROWNUM <= 20

Any ideas?!
Re: NUMROWS problem (in PHP) [message #13917 is a reply to message #13914] Mon, 02 August 2004 13:05 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Hopefully these links will be helpful:

How ROWNUM works

Paging through result sets #1

Paging through result sets #2
Re: NUMROWS problem (in PHP) [message #13918 is a reply to message #13917] Mon, 02 August 2004 13:06 Go to previous message
ally
Messages: 6
Registered: November 2003
Junior Member
Thanks!
Previous Topic: Connect to Oracle-Server via php
Next Topic: install DBD::Oracle on Fedora
Goto Forum:
  


Current Time: Thu Mar 28 16:20:07 CDT 2024