Prepared Statements Rows Selected
| From: | Ron Piggott | Date: | Mon, 23 May 2011 22:53:14 +0000 |
| Subject: | Prepared Statements Rows Selected | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47802@lists.php.net to get a copy of this message | ||
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