[PHP-DB] Prepared Statements Rows Selected

[Ron Piggott]

What command will tell me the # of rows the SELECT query retrieved using 
Prepared Statements.


$dsh = 'mysql:host=localhost;dbname='.$database;
$dbh = new PDO($dsh, $username, $password);

$stmt = $dbh-prepare($query);

$stmt-bindParam(':email', $email);
$stmt-bindParam(':pass', $pass);

$stmt-execute();


I am looking for the equivalent of mysql_numrows

mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or die( Unable to select database);
$result=mysql_query($query);
$num=mysql_numrows($result);


Ron

The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info  

Re: [PHP-DB] Prepared Statements Rows Selected

[Giff Hammar]

$stmt-rows() should give you the number of rows returned.

Giff

On Mon, 2011-05-23 at 18:53 -0400, Ron Piggott wrote:
 What command will tell me the # of rows the SELECT query retrieved using 
 Prepared Statements.
 
 
 $dsh = 'mysql:host=localhost;dbname='.$database;
 $dbh = new PDO($dsh, $username, $password);
 
 $stmt = $dbh-prepare($query);
 
 $stmt-bindParam(':email', $email);
 $stmt-bindParam(':pass', $pass);
 
 $stmt-execute();
 
 
 I am looking for the equivalent of mysql_numrows
 
 mysql_connect('localhost',$username,$password);
 @mysql_select_db($database) or die( Unable to select database);
 $result=mysql_query($query);
 $num=mysql_numrows($result);
 
 
 Ron
 
 The Verse of the Day
 “Encouragement from God’s Word”
 http://www.TheVerseOfTheDay.info  



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php