Re: Interbase: Number recs
| From: | David Tod Sigafoos | Date: | Mon, 02 Oct 2000 17:33:00 +0000 |
| Subject: | Re: Interbase: Number recs | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3221@lists.php.net to get a copy of this message | ||
Hello Todd,
Not sure about interbase BUT in MySql it would be mysql_num_rows()
DSig
David Tod Sigafoos
Monday, October 02, 2000, 10:20:58 AM, you wrote:
TC> Is there an easier way to get the number of records from a SELECT?
TC> +++
TC> $stmt = 'SELECT PH_CD,PH_ROLL,PH_FRAME_LABEL,PH_ID FROM PHOTOS';
TC> $sth = ibase_query($stmt,$dbh);
TC> $ct = 0;
TC> while ($row = ibase_fetch_row($sth)) {
TC> ++$ct;
TC> };
TC> $totalrecs = $ct;
TC> +++
TC> What is the method to go to the first record?
TC> Todd
TC> --
TC> Todd Cary
TC> Ariste Software
TC> todd@aristesoftware.com
--
Best regards,
David mailto:dsig@teleport.com