Re: SORT resutls

thanks that did it. "Beau Lebens" <B.Lebens@curtin.edu.au> wrote in message news:A2B098B4E624D511BED900508BB92A5701CA527E@exmsb02.curtin.edu.au... > ORDER BY foo [ ASC | DESC ] > > // -----Original Message----- > // From: CrossWalkCentral [mailto:webmaster@crosswalkcentral.net] > // Sent: Wednesday, 22 May 2002 10:42 AM > // To: php-db@lists.php.net > // Subject: [PHP-DB] SORT resutls > // > // > // I am using the code bellow however this is not a proper way > // to sort my data > // it groups my data. Is their a similar command that i can > // replace the group > // with like sort? > // > // "SELECT * FROM supportsys WHERE status=1 and know=0 GROUP BY $G"); > // > // > // > // -- > // PHP Database Mailing List (http://www.php.net/) > // To unsubscribe, visit: http://www.php.net/unsub.php > //