Re: Alphabetizing SQL Data

2008-10-22 Thread tapupartforpres
Great thanks. Let me give that a try. I appreciate your help. On Oct 21, 7:22 pm, "Jon Bennett" <[EMAIL PROTECTED]> wrote: > > the best way to do this is via your sql code not your php code. > > You'll probably need to add "ORDER BY `name`' to the end of the sql > > statement or something simil

Re: Alphabetizing SQL Data

2008-10-21 Thread Jon Bennett
> the best way to do this is via your sql code not your php code. > You'll probably need to add "ORDER BY `name`' to the end of the sql > statement or something similar. actually, you want to do teh compete opposite with cake! you want to use the order by argument in the find method, eg: $this->

Re: Alphabetizing SQL Data

2008-10-21 Thread Miguel Miranda
have you tried using order by ? On Tue, Oct 21, 2008 at 3:11 PM, tapupartforpres <[EMAIL PROTECTED]>wrote: > > Hello. I am assuming this is more of a .php question, but it is in > Cake's framework. > > I have a site that I took over that had a listing of 50 wineries with > their name and URL pul

Re: Alphabetizing SQL Data

2008-10-21 Thread Turnquist, Jonah
the best way to do this is via your sql code not your php code. You'll probably need to add "ORDER BY `name`' to the end of the sql statement or something similar. On Oct 21, 2:57 pm, "Miguel Miranda" <[EMAIL PROTECTED]> wrote: > have you tried using order by ? > > On Tue, Oct 21, 2008 at 3:11 PM

Alphabetizing SQL Data

2008-10-21 Thread tapupartforpres
Hello. I am assuming this is more of a .php question, but it is in Cake's framework. I have a site that I took over that had a listing of 50 wineries with their name and URL pulling from the SQL data. I added 20 additional wineries but are listed with the id of 51-71. It is pulling the id and