How to use FIRST select clause in IUS V9.12.UC2

Hi,All: We are using PHP3 to access INFORMIX-Universal Server Version 9.12.UC2 on UNIX (solaris) to build the dynamic webpage. Our Question is how to achieve that show first 15 selected results in first page and then show next 15 selected results in next page. We have tried to use FIRST select clause in the query just like the following format: select first 15 username from customer; but it failed, system responsed that "Syntax Error",we guessed that Maybe this SELECT CLAUSE only can be used in Enterprise Dynamic Server, Right? It it is , How to achieve it without using SELECT CLAUSE ? Waiting for your help . Thanks in advance. Thanks a lot ! 2000.03.17

>Subject: How to use FIRST select clause in IUS V9.12.UC2 >From: "Harrison Teng" harrison@sh.east.cn.net >Date: 17.03.00 06:14 W. Europe Standard Time >Message-id: <8asepf$32e$1@info.bta.net.cn> > >Hi,All: > We are using PHP3 to access INFORMIX-Universal Server Version 9.12.UC2 on >UNIX (solaris) to build the dynamic webpage. > Our Question is how to achieve that show first 15 selected results in >first page and then show next 15 selected results in next page. > We have tried to use FIRST select clause in the query just like the >following format: > >select first 15 username from customer;> >but it failed, system responsed that "Syntax Error",we guessed that Maybe >this SELECT CLAUSE only can be used in Enterprise Dynamic Server, Right? > It it is , How to achieve it without using SELECT CLAUSE ? > > Waiting for your help . > >Thanks in advance. >Thanks a lot ! > 2000.03.17 > > > Upgrade to 9.20.UC1. Nona