mysqli->prepare('Update')
<p>is this code ok? because I don't get my db updated and I get no errors. Thank you.</p>

<pre><code>//connect to db

$email = $mysqli-&gt;real_escape_string($_POST['email']);
$bo = $mysqli-&gt;real_escape_string($_POST['bo']);
$p1 = $mysqli-&gt;real_escape_string($_POST['p1']);
$p2 = $mysqli-&gt;real_escape_string($_POST['p2']);
$dt = $mysqli-&gt;real_escape_string($_POST['dt']);

$dt = new DateTime("2012-07-01 13:13:13", new DateTimeZone('Europe/Paris'));

//more validation code...

$stmt = $mysqli-&gt;prepare('UPDATE table SET Password=?, R_P=?, R_T=? WHERE E_mail=?')
$stmt-&gt;bind_param("ssss", $p2, $p2, $dt, $email); 
$stmt-&gt;execute();
$stmt-&gt;close();

$mysqli-&gt;close();

//send email
</code></pre>

<p><strong>I had no errors because I forgot to add on my page a thing that I always add on all my pages:</strong></p>

<pre><code>// check for errors
require_once('check_all_errors.php');
</code></pre>
