Re: DESC order results
| From: | Silvio Porcellana | Date: | Sun, 13 Jan 2008 19:43:35 +0000 |
| Subject: | Re: DESC order results | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-267195@lists.php.net to get a copy of this message | ||
$query = 'SELECT * FROM eChart WHERE clientNo = "2" ORDER BY ChartNo DESC';If you want just one record: $query = 'SELECT * FROM eChart WHERE clientNo = "2" ORDER BY ChartNo DESC LIMIT 0, 1'; BTW, you'd better ask the MySQL mlist: http://lists.mysql.com/ HTH, cheers Silvio