Great! That worked! Thanks.
--- In php_mysql@yahoogroups.com, Michael <m...@...> wrote:
>
> try
>
> ORDER BY `title`, `year`
>
> and/or specify the direction like
>
> ORDER BY `title` ASC, `year` DESC
>
> yarr!
>
>
> pirate_lenny wrote:
> >
> >
> > I've got a title column and a year column. I'd like to be able to sort
> > it so that all of the same titles are together and then sorted
> > chronologically.
> >
> > How do I do this?
> >
> > Here's what I have:
> >
> > SELECT ....
> > ORDER BY title AND year
> >
> > But, that gives me an unsorted list. How do I fix?
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
