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
