Using PDO to query a database?

[Mr Chris]

Hello All,

 

Trying to write a log-in script using PDO.  But have one question.  With the below when I query the database and even run a print_r on $RES nothing is outputted?

 

Any ideas?

 

Thanks

 

if (isset($_POST['Submit']))
{
$email  = $_POST['email'];
$password  = $_POST['password'];

$QUERY = $dbc->prepare("SELECT email, password FROM tbl WHERE email = :email");
$QUERY->bindParam(':email', $email);
$QUERY->execute();
$RES = $QUERY->fetchColumn();

echo "Email is:".$RES['email'];
echo "PW is: ".$RES['password'];
print_r($RES);
}

 

[AbraCadaver]

fetchColumn() as you are using it only returns the value of the first column in the first row.  You probably want fetch() to fetch the entire row.  Also, if there is nothing there, then there were no results returned.