Mailing List Archive


Back to the month index Back to the list index
Joshua J. Kugler (jkugler@inreach.com)
Wed, 12 Nov 1997 13:05:24 -0800 

Message-Id: <3.0.2.16.19971112130524.3e2fd460@205.138.224.216>
Date: Wed, 12 Nov 1997 13:05:24 -0800
From: "Joshua J. Kugler" <jkugler@inreach.com>
Subject: Re: Showing query results 10 at a time

At 01:24 PM 11/9/97 -0500, Parameshwar Babu espoused the following wisdom:
()Suppose a msql query is called thru' phtml and the query returns about
()30 records:
()
()1. I want to show the results in 3 stages in steps of 10 records in a
()page so that the visitor can browse the results by pressing "next 10
()hit" button.
()Is it possible to do it without re-executing the query each time?
()
()2. For e.g, visit the page http://www.pppindia.com/trade/trade.html
()where there are atleast 10-20 postings in a day with about 3000 hits per
()day. If I convert this perl cgi into phtml-mSQL, will the mSQL be able
()handle the burden? I hear people saying msql to be very vulnerable.

You could do temp tables, but that could get messy. Just redo the query
each time. What I do for each time is perform the same query, and then
depending on which cycle it is, I dataseek() to the record I need, and
display ten records, then quit.

j----- k-----

Joshua J. Kügler
Computer Consultant--Web Developer
jkugler@inreach.com - jkugler@bigfoot.com - jk@iname.com - joshuajk@usa.net
http://www.cwebpages.com/jkugler
Every knee shall bow, and every tongue confess, in heaven, on earth, and
under the earth, that Jesus Christ is LORD -- Count on it!