Statement won't work

[StephenL]

ok I have a prepared statement that looks like this..

$stmt2 = $dbh->prepare('INSERT INTO logs VALUES (logDate,ipAddress,userName,browserType) VALUES (?,?,?,?)');

and I run the statement with code that looks like this ...

			 if(!$stmt2->execute(array($logDate,$ip,$_POST['username'],$browerType))) {
				 echo "<p>There was an error in processing your login, please conatact site admin.";
				 exit;
			 }else{
                                //set session and what not here
}

but when I run this I just the error message and I'm not sure why. Here is how I get the values for the query.

$ip = $_SERVER['REMOTE_ADDR'];
	$logDate = date("Y-m-d");
	$browserType = $_SERVER['HTTP_USER_AGENT'];

Of course the

$_POST['username']

is coming from the form. Any ideas would be great..

Stephen

[bradgrafelman]

What's the error message returned from the SQL server?

[StephenL]

There is no error and I'm new to using PDO so I'm not sure how to error check it, searching on that now. I have posted this code in another post with a different problem, I will re-post so as to show new problem.

	//Get vars for log in insert.
	$ip = $_SERVER['REMOTE_ADDR'];
	$logDate = date("Y-m-d");
	$browserType = $_SERVER['HTTP_USER_AGENT'];

echo $ip."<br>".$logDate."<br>".$browserType;

 //Make the prepared statment
 $stmt = $dbh->prepare('SELECT userName,Password FROM members WHERE userName = ? AND Password = ?');
 $stmt2 = $dbh->prepare("INSERT INTO logs VALUES (logDate,ipAddress,userName) VALUES (?,?,?)");

 if ($stmt->execute(array($_POST['username'],$_POST['password']))) {

	 //There is a user so check to see if pass is correct.
	  $row = $stmt->fetch();


	 if ($row['Password'] == $_POST['password']) {


		 //insert the log in information into the logs table
		 if(!$stmt2->execute(array($logDate,$ip,$_POST['username']))) {
			 echo "<p>There was an error in processing your login, please conatact site admin.";
			 exit;
		 }else{
			 //The password is correct so reg. sessions
		     $_SESSION['user'] = $row['userName'];			 
		     $salt = $_SERVER['HTTP_USER_AGENT'];
             $salt .="staffcoop";
             $_SESSION['fingerprint'] = md5($salt);
		     //header("Location: newslist.php");
			 echo "horyaa";
		 }


	 }else{
		 //Login failed send them to error page with login form.
		 emailAdmin($_POST['username'],$ip,$logDate);
		 header("Location: error.php");
	 }         		
}

Thanks for any help you can give me, I'm at a loss.