OraFAQ Forum: Open Database Interfaces » NUMROWS problem (in PHP)

Home » Open Source » Open Database Interfaces » NUMROWS problem (in PHP)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

NUMROWS problem (in PHP) [message #13914]

Mon, 02 August 2004 11:19

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?!

Report message to a moderator