Hi Marek,
Sorry about the confusion, let me explain.
With default sorting (without $TheOrder) I am getting this:
(using $sqlle = "select * from $table_namee where price <=$max and spacee
>=$min order by custno,price LIMIT $limitvalue1, $limit"; )
company1
1plan1
1plan2
company2
2plan1
2plan2
company3
3plan1
3plan2
etc
Which is the perfect results that I am looking for. This is the code i am
using to get that output:
if(empty($Tcompany))
{ $Tcompany = $row[4]; }
elseif($Tcompany != $row[4])
{
//echo plan and html here
$Tcompany = $row[4];
}
So far so good, I am getting everything exactly the way I want it.
Now I want to give the user an ability to sort the data according to the
way he wants it....so I am using:
($sqlle = "select * from $table_namee where price <=$max and spacee=$min
order by $TheOrder, custno LIMIT $limitvalue1, $limit)
and the results are coming out jumbled like this:
company1
1plan1
company3
3plan1
company1
1plan2
company2
2plan1
2plan2
I do basically want to order by both (as you said)...first order by
$TheOrder and make sure it displays by "company"....
Rob from the list said something about caching the result...but I really
couldnt understand...am looking into it though.
Any ideas or questions?
Thanks,
-Ryan
> Hi again,
>
> I cannot spot any difference from the original that you already have.
>
> Marek
>
> Ryan A wrote:
> > Hi,
> > Thanks for replying.
> >
> > Yes, i know ordering by both at once as if they were on the first place
is
> > illogical, thats why I need a php answer to "wangle" this....I want the
> > desired output to be the same when the sort by was by default
"price"..eg:
> >
> > company1
> > 1plan1
> > 1plan2
> >
> > company2
> > 2plan1
> > 2plan2
> >
> >
> > company3
> > 3plan1
> > 3plan2
> >
> > etc
> >
> > What do you think?
> >
> > Cheers,
> > -Ryan
> >
> >
> >
> >>How do you mean it? Order by both at once as if they were on the first
> >>place? Is this logicaly possible?
> >>
> >>You should post your desired output.
> >>
> >>Marek
> >>
> >>Ryan A wrote:
> >>
> >>>Hi Marek,
> >>>Thanks for replying.
> >>>
> >>>If I do that I get the companies neatly but the not sorted according to
> >
> > the
> >
> >>>$TheOrder...:-(
> >>>
> >>>Yep, am checkign user inputs.
> >>>
> >>>Cheers,
> >>>-Ryan
> >>
> >>
> >>
> >
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
