How to check if there are results with Prepared Statements

calving

New Member
In the past I would do something like so:\[code\] $sql = 'SELECT * FROM customers WHERE customer_email="' . mysql_real_escape_string($_POST['customer_email']) . '" '; $res = mysql_query($sql); // if there are no hits... if(mysql_num_rows($res) == FALSE) {\[/code\]Today I am doing the same thing however with prepared statements:\[code\] $stmt = $dbh->prepare("SELECT * FROM customers where customer_email = ? LIMIT 1"); if ($stmt->execute(array($_POST['customer_email']))) {\[/code\]The 2nd line of my prepared statement if($stmt... is that "if this query gets a result" or is it "if this query is executed regardless of results or not ie if it executes without error".What I'm trying to work out is with prepared statements how do you do the equivalent of mysql_num_rows() == FALSE?Thanks!!
 
Back
Top