Re: Alphabetical pagination

On Wednesday 15 July 2009 16:21:22 tedd wrote: > At 12:38 PM -0700 7/14/09, Miller, Terion wrote: > >I am trying to make a page that displays a-z like a b c d e etc as links > >then when you click open one it reloads itself and shows only the query > >results that go with that letter...i'm not getting it....I get a page that > >says ARRAY over and over... > > > >What I have so far: > > -snip- > > Why not have MySQL sort the data instead of using php? > > For example (from memory -- use with caution) > > SELECT name FROM restaurant ORDER BY name DESC LIMIT $offset, 1 > > Then just change the offset to go up and down the list. > > Cheers, > > tedd > -- > ------- > http://sperling.com Uï\= > 3§±s8 ϹÏNhttp://ancientstones.com > http://earthstones.com You could do what Tedd suggested, but use MySQL to actually limit the results it returns you by using a like clause, i.e. WHERE somefield LIKE 'a%'. *ducks to avoid people throwing things at him. I know it's slow!* -- Thanks, Ash http://www.ashleysheridan.co.uk