Re: Sorting MySQL queries
| From: | Børge Holen | Date: | Mon, 06 Nov 2006 22:53:25 +0000 |
| Subject: | Re: Sorting MySQL queries | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-244291@lists.php.net to get a copy of this message | ||
On Monday 06 November 2006 08:15, clive wrote:
> > Current code:
> > $query = "SELECT subject FROM table ORDER BY subject asc";
> > $result = mysql_query($query);
>
> I dont seen any php code to do any sorting,just a mysql query, perhaps a
> mysql list or maybe you should try doing it in php yourself first.
>
> Not that I know the answer, but mysql does have a substring function,
> perhaps it can help.
substring is quite powerful. Never tried one of those though
--
---
Børge
Kennel Arivene
http://www.arivene.net
---