Re: Re: Listing a table /Limit

On Wednesday 20 November 2002 22:12, Matt Schroebel wrote: > I was thinking you'd start at the beginning, displaying row 0 through > row 19, and then have a next link, that will show rows 20 through 39, > and so on. Read the question again :) That's not what the OP wants. > > And how would I find out which portion (row number) the row > > would be in, > > that I would like to see in a listing? The only way I can think of to achieve this is to read all your rows into an array and process it from there. I'm not sure whether it's possible in SQL -- but then again if you was looking for an SQL solution you would have posted to the php-db list! > > <Q> > > Hello, how would I go about listing a portion of a MySQL > > table, without an > > overall selection criterium? I have a unique index field, but > > it's a string > > and not autoincremented (but manually and with gaps). I just > > want to go to > > one particular row (query on that index field) and then list, > > say, 20 rows > > before that point and 20 rows after it. So I can create an > > output of 41 > > rows in a HTML table. Is there something like the dBase SKIP and GOTO > > command? Should I do a query for each individual row (and get > > 41 result > > sets) or can I somehow walk through 1 result set ? > > </Q> -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Laundry is the fifth dimension!! ... um ... um ... th' washing machine is a black hole and the pink socks are bus drivers who just fell in!! */