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 --- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php