Hi John, Sorry about that. I should have explained what I meant. The basic problem that I'm trying (desparately) to skirt around is a troublesome paging problem.
The basic query loads all files in the db sorted by name. The first page that displays has a "Next 20" button that loads the next page, and so on until the last page which has no "Next 20" button, but deadends. The problem I've faced today, is that I originally allowed a "Sort by Country" button to appear on each page -- thereby messing up the original paging. It, of course, returned to the first page (which didn't know squat about whatever the calling page asked for). Thus, the whole thing froze -- which is to be expected. The resolution, in my mind, is simple: do not have that button anywhere but on the first page (it took me a long time to figure that one out, duhh :>). The second solution, is somewhat better: using a sub-query, which will re-paginate all right, but I still need to retain the alpahbetical order of names as well. Perhaps I can't have both. (I think I'll have to try both -- my mind's a bit blitzed from the problems I've resolved today!) So, that's what I'm trying to do. The page I'm working on is a protype for about three other similar ones. Regards, Andre On Wednesday 05 June 2002 10:22 pm, you wrote: > What do you mean it'll "trash the current paging" ?? Can you give a more > detailed explanation? > > Results 30-60 of one result set sorted by a certain column will be > totally different than results 30-60 of a result set sorted by a > different column. > > So the paging would have to start over, anyhow. Unless you're looking to > maintain the same 30 results in the new result set, like my previous > email mentioned... > > ---John Holmes... > > > -----Original Message----- > > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, June 05, 2002 10:19 PM > > To: Miguel Cruz > > Cc: [EMAIL PROTECTED] > > Subject: Re: [PHP] Modifying the sort order of a query > > > > Thanks Miguel, > > > > I haven't tried the sub-query approach yet, but that does seem to be > > the > > > way > > to do this. My fear is that it will trash the current paging (which > > took > > > forever to get working with the current setup). Actually, after trying > > my > > > original code again in another smaller select function, I'm wondering > > whether > > I even need this refined search option -- it might be a case of > > 'overkill'. > > Still, it's got my curiosity going. > > > > The problem seems to be centered on how I wrote the original code > > (it's > > > amzing how it's changed!). I think I'll have to re-write using switch > > functions to clarify exactly what I want it to do. > > > > Regards, > > Andre > > > > On Wednesday 05 June 2002 09:43 pm, you wrote: > > > My understanding was that he wanted to see the same 30 rows, but > > sorted > > > in > > > > > a different way. > > > > > > For instance, he wanted to see entries 30-60 as sorted by age, but > > to > > > have > > > > > those sorted by height when displayed. > > > > > > miguel > > > > > > On Thu, 6 Jun 2002, Bogdan Stancescu wrote: > > > > That's at least curious - limiting and offsetting will most > > certainly > > > > > affect the results which are then sorted... I don't think that's > > what > > > he > > > > > > was after. Just my 2c. > > > > > > > > Bogdan > > > > > > > > Miguel Cruz wrote: > > > > >Try a sub-select: > > > > > > > > > >SELECT * FROM (SELECT * FROM rap ORDER BY > > > > rcountry,rcity,rsname,rfname > > > > > > >DESC LIMIT 30 OFFSET 30) ORDER BY whatever; > > > > > > > > > >miguel > > > > > > > > > >On Wed, 5 Jun 2002, Andre Dubuc wrote: > > > > >>Apache 1.3.23 + PHP 4.1.2 + PostgreSQL 7.2 > > > > >> > > > > >>I have a query that sorts by name, country, and city, then pages > > in > > > > > >> groups of 30 records. Originally, I had also coded two buttons: > > > > "Sort > > > > > > >> by Country', 'Sort by City' since I wanted to offer users the > > > > options > > > > > > >> of these choices. > > > > >> > > > > >>Unfortunately, these buttons work well, but re-select the whole > > > > shebang > > > > > > >>(which I guess is to be expected), destroying any paging that > > had > > > > > >> already started. I've tried all sorts of ways, tried > > re-arranging > > > the > > > > > > >> order of execution, but the result is the same. > > > > >> > > > > >>I'm at a loss on how to proceed. I've deleted the choice (for > > now) > > > and > > > > > > >> run it as a simple select order by name query.The problem seems > > to > > > be: > > > > >> I need a sub-query select function that retains the original > > query, > > > > > >> simply re-organizing it according to the new criteria, and > > retains > > > the > > > > > > >> original paging. (Perhaps I shouldn't care whether the paging > > is > > > > > >> messed up as long as the results are the same.) > > > > >> > > > > >>I realize that the way it's set up below, it will automatically > > send > > > a > > > > > > >> NEW query, which is not what I want. I'd like to work with the > > > > results > > > > > > >> of the original query and modify it with the new criteria > > > > >> > > > > >>Any suggestions how I can achieve this, or whether it's even > > > > possible? > > > > > > >> I would greatly appreciate any assistance or comments. > >> > >>********************************************************************** > > * > > > > > >>*************** > > > > >> > > > > >>Snippet of offending code: > > > > >> > > > > >><?php > > > > >> > > > > >>//snippet follows: > > > > >> > > > > >>print "<input type="submit" name="submit" value="Sort by > > City">"; > > > > > >>print " "; > > > > >>print "<input type="submit" name="submit" value="Sort by > > Country">"; > > > > > >>// more code > > > > >> > > > > >>if($_POST['submit'] == "Sort by Name"){ > > > > >> $query = "SELECT * FROM rap ORDER BY > > > > >> rsname,rfname,rcountry,rcity,DESC LIMIT 30 OFFSET 30"; > > > > >>} > > > > >>elseif($_POST['submit'] == "Sort by Country"){ > > > > >> $query = "SELECT * FROM rap ORDER BY > > > > >> rcountry,rcity,rsname,rfname DESC LIMIT 30 OFFSET 30"; > > > > >>} > > > > >> > > > > >>//more code, including paging functions > > > > >>?> > >> > >>********************************************************************** > > * > > > > > >>********************* > > > > >> > > > > >>Tia, > > > > >>Andre > > > > -- > > Please pray the Holy Rosary to end the holocaust of abortion. > > Remember in your prayers the Holy Souls in Purgatory. > > > > May God bless you abundantly in His love! > > For a free Cenacle Scriptural Rosary Booklet: > > http://www.webhart.net/csrb/ > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php -- Please pray the Holy Rosary to end the holocaust of abortion. Remember in your prayers the Holy Souls in Purgatory. May God bless you abundantly in His love! For a free Cenacle Scriptural Rosary Booklet: http://www.webhart.net/csrb/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
