Andre Don't know how useful this will be to you .. but was following thru this and thought why wouldn't you include a page with a switch statement or the like into all the pages... so that all pages know about but not always use the queries ... so that you can have it sorted by any and everything you want...
any way just a thought cheers Peter -----Original Message----- From: Andre Dubuc [mailto:[EMAIL PROTECTED]] Sent: Thursday, 6 June 2002 1:27 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Modifying the sort order of a query Hi John, Oh, my apologies again. I haven't thought this through enough. I'm sorry that I've wasted your time. >"Is it messing up when you click Next 20? Does it go > back to the old sorting, or what? If you're looking at page 4 sorted by > name, then you want to sort by country, you can't go back to page 4 . . ." Yes, that's what I was attempting to do. Perhaps I was too close to the code to really visualize the basic flow. It went back to the first page, and froze -- that's because the first page had no reference to the "new" query -- it had no reference to a new query being made since "Page 1" has it's own code/query set that did not include the restructuring of the query that Page 4 attemped to do. So, I don't think it's possible to accomplish an "in-process" sort without re-paginating the whole thing. I'll probably have to do it ONLY on the first page, and not offer a continuous option on every page. [Btw, nothing is public yet . . . I'm still putting the pieces together -- hopefully sometime in September.] Further, I've changed most of the code that I first wrote, attempting to tryout the concepts. Regards, Andre On Wednesday 05 June 2002 11:01 pm, you wrote: > I still really don't understand. You have a list of documents, 20 per > page. You want to be able to sort it by country or another column, yet > still display them in alphabetical order? > > Maybe an example page would help...is this page public anywhere? > > Like I said before, if you sort by new columns, then your paging has to > start over back at the beginning. You said it already did this, but it > still is messing up. Is it messing up when you click Next 20? Does it go > back to the old sorting, or what? If you're looking at page 4 sorted by > name, then you want to sort by country, you can't go back to page 4 > (well, you can, but it's going to be a whole new page four because of > the new sort order). > > Example page will really help here; maybe I'm just slow in visualizing > this. We can take this off the list if necessary, too. > > ---John Holmes... > > > -----Original Message----- > > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, June 05, 2002 10:49 PM > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > Subject: Re: [PHP] Modifying the sort order of a query > > > > 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/ -- 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
