Re: Re: re-order a sql result
| From: | Burhan Khalid | Date: | Mon, 18 Jul 2005 13:34:36 +0000 |
| Subject: | Re: Re: re-order a sql result | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-218864@lists.php.net to get a copy of this message | ||
Mark Rees wrote:
""Ross"" <ross@aztechost.com> wrote in message news:D9.31.61486.D7A8BD24@pb1.pair.com...If you don't want to re-query the information, some clever table sorting javascript-fu is available at http://www.brainjar.com/dhtml/tablesort/I have a query $query = "SELECT * FROM sheet1 WHERE '$filter' LIKE '$search_field%'"Simply requery the database for each search. For example, this orders the results by surname from a-z $query = "SELECT * FROM sheet1 WHERE '$filter' LIKE '$search_field%' ORDER BY surname ASC";