Just wondering if anyone could tell me how reliable the DESC order
option is going to be when I am parsing thousands of records where they
are multiple ChartNo's for the same clientNo. Or is there a better way
to grab the most recent ChartNo.
$link = mysql_connect('localhost', 'myuser', 'mypassword') or die('Could
not connect: ' . mysql());
mysql_select_db('mydatabase') or die('Could not select database');
$query = 'SELECT * FROM eChart WHERE clientNo = "2" ORDER BY ChartNo
DESC';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
$line = mysql_fetch_array($result, MYSQL_ASSOC);
// Just for testing....
print mysql_num_rows($result);
Thanks,
Dan
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
