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()
[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
Have you tried using the $rows = $sth-rows() after you execute to get the total
rows returned?
On Wed, 31 Oct 2001 00:43:00 +, Mark Worsdall [EMAIL PROTECTED] wrote:
Hi,
I want to alter this statement so it returns the number of records.
$prep = SELECT COUNT(*) FROM go.objectives WHERE
I'm new to this list, and new to mySQL but used SQL with DB2 years ago, so
here goes my try at answering this: have you tried select count(*) as
your_variable_name From etc .etc.etc.
Anne
- Original Message -
From: Mark Worsdall [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: