Er... but the original poster wanted a count of rows returned by a particular query... your method just returns the number of rows in the table...
Rich -----Original Message----- From: @ Edwin [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 17:21 To: Jon Haworth; 'Diana Castillo' Cc: [EMAIL PROTECTED] Subject: Re: [PHP] run query Or, "Jon Haworth" <[EMAIL PROTECTED]> wrote: > Hi Diana, > > > After I run a query lik this, > > $db->query($sql); > > > > what is the quickest way to find out how many > > records result? > > Look into mysql_num_rows (or the equivalent if you're not using MySQL) ... you can even do it faster by using a "select count(*) as something from some_table" More info (found in the manual): http://www.faqts.com/knowledge_base/view.phtml/aid/114/fid/12 HTH, - E -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
