Re: using LIMIT

On Fri, Apr 06, 2001 at 02:15:34PM +0300, Dainius Vaskelis wrote: > I suppose that you are using MySQL (because of LIMIT operator in SQL query) I m using PostgreSql > So: > > In the second query i write a query whereby i say > > $result=pg_Exec($database,"SELECT mem_id,name from search LIMIT $count"); > > Now here i display the the first 10(say $count=10) records. > > Now I know to display the other records i can say > > $result=pg_Exec($database,"SELECT mem_id,name from search LIMIT > $count,$count"); > > but what condition to give to display pages of more than $count records > > i.e how do i give for next existing page. > > LIMIT operator has two parameters: amount of records of result, offset in > result. > > So in order to paginate your output you need such scheme: > > $count = 10; > $offset = 0; > <loop begin> > ... > $result=pg_Exec($database,"SELECT mem_id,name from search LIMIT > $count,$offset"); > $offset += $count; > ... > <loop end> What shall the loop be like,i mean the condition for terminating the search. > If you want to use this to make output as search engines do (output first 10 > recs on the first page, and output links of other pages), so you need to > modify a litle bit. You need to pass by parameters page no, in other pages > link: > > $count = 10; > $offset = 0 > if is_set(page_no) { > $offset = $page_no * $count; > } > What is page_no here and doesn't $offset get overidden here > ... > $result=pg_Exec($database,"SELECT mem_id,name from search LIMIT > $count,$offset"); > ... > > Hope it'll help you. Good luck. I was of great help but i want more help or URL or atleast a practical reference on this. Pls if possible look at the forms Regards, -- The secret of the universe is @*&í!'ñ^#+ NO CARRIER __ _ _ _ _ |_|_||_||_||\/||_|| \ _|| || || \| || ||_/

<HTML> <BODY> <?php echo("$mem_id \n"); $count=10; $offset=0; $database=pg_connect("dbname=search user=pro"); if is_set(page_no) { $offset=$page_no*$count; } while(echo("<INPUT TYPE=SUBMIT VALUE=Submit NAME=Submit>");){ $result=pg_Exec($database,"SELECT * from search ". "where acc_no='$mem_id' LIMIT $count,$offset"); for ( $i=0 ; $i < pg_NumRows($result) ;$i++) { echo pg_Result($result,$i,0);echo"\t"; echo pg_Result($result,$i,1);echo"\t"; echo pg_Result($result,$i,2);echo"\t"; echo pg_Result($result,$i,3);echo"\t"; echo "<BR>"; } $offset+=$count; } ?> </BODY> </HTML>