Re: Question: Sorting through table headers?

--- On Sun, 9/13/09, Parham Doustdar <parham90@gmail.com> wrote: > From: Parham Doustdar <parham90@gmail.com> > Subject: [PHP] Question: Sorting through table headers? > To: php-general@lists.php.net > Date: Sunday, September 13, 2009, 6:55 AM > Hello there, > I've been asked to create something like the tables you > usually see, where the headers are actually links and when > you click the links, the table gets sorted based on the > header. Are there any classes that you know of that would do > the job? My current idea is to return an array of the colomn > which contains the data you want to sort on (like 'name') > then sort the array and do something like: > [code] > for (i = 0; i < length(array); i++) > mysql_query("select * from table where 'name' = > ${aray[i]}"); > [/code] Your code looks like you're filtering and not sorting. You should revisit the basics of SQL syntax. > Any better algorithms anyone? > Thanks! > -- > --- > Contact info: > Skype: parham-d > MSN: fire_lizard16 at hotmail dot com > GoogleTalk: parham90@gmail.com > Twitter: PD90 > email: parham90 at GMail dot com