>
> $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