On Fri, 2009-07-17 at 11:55 -0400, PJ wrote:
> Ashley Sheridan wrote:
> > On Friday 17 July 2009 16:35:10 PJ wrote:
> >
> >> I noticed the thread on pagination here just after posting to mysql. But
> >> I am using php/mysql ;-)
> >> I have some rather complicated ordering problems:
> >> 1. n
On Fri, Jul 17, 2009 at 9:35 AM, PJ wrote:
> 4. when ordering by title, results are totally different for ASC & DESC;
> not the same data at all (Is the ordering done on the entire db? )
Yes, sort of. ORDER BY is applied to the results of the entire query.
Then LIMIT takes a slice out of the res
Ashley Sheridan wrote:
> On Friday 17 July 2009 16:35:10 PJ wrote:
>
>> I noticed the thread on pagination here just after posting to mysql. But
>> I am using php/mysql ;-)
>> I have some rather complicated ordering problems:
>> 1. need to order by 2 fields title, sub_title
>> 2. need to dis
Ashley Sheridan wrote:
> On Friday 17 July 2009 16:35:10 PJ wrote:
>
>> I noticed the thread on pagination here just after posting to mysql. But
>> I am using php/mysql ;-)
>> I have some rather complicated ordering problems:
>> 1. need to order by 2 fields title, sub_title
>> 2. need to dis
On Friday 17 July 2009 16:35:10 PJ wrote:
> I noticed the thread on pagination here just after posting to mysql. But
> I am using php/mysql ;-)
> I have some rather complicated ordering problems:
> 1. need to order by 2 fields title, sub_title
> 2. need to display 10 items per page (hundreds, i
I noticed the thread on pagination here just after posting to mysql. But
I am using php/mysql ;-)
I have some rather complicated ordering problems:
1. need to order by 2 fields title, sub_title
2. need to display 10 items per page (hundreds, if not 1000s or pages)
3. order by ASC or DESC makes
6 matches
Mail list logo
