At 11:34 AM +0100 11/1/01, Harald Fuchs wrote: >In article <p05100345b8063ddb205a@[192.168.1.31]>, >Paul DuBois <[EMAIL PROTECTED]> writes: > >> [snip] >>> Of all the methods suggested I like the look of the one above and will >>> try that one first. >>> >>> $count = $sth->fetchrow_array(); >>> >>> $rows = $sth->rows() > >> Note that use of rows() to get the row count for a SELECT is deprecated >> in the DBI docs, which say that if you want to know the number of rows >> in a result set, fetch and count them. (The reason is that rows() >> just doesn't work at all for some database engines. On the other hand, >> it appears to work just fine for MySQL...) > >... unless you use 'mysql_use_result' instead of the default >'mysql_store_result'.
Another reason to avoid rows(). :-) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php