$link = new mysqli(MYSQL_NAME, MYSQL_USER, MYSQL_PASS, MYSQL_DBNAME);
if ( mysqli_connect_errno() )
{
echo 'Too many users connected to the database!<br />Please try again later.';
}
else
{

$query = "UPDATE time_actions SET proc_start=NOW() WHERE pid=555";
$result = $link->query($query);

echo 'Going to sleep now<br />';

sleep(10);

echo 'WAKED UP!<br />';

$query = "UPDATE time_actions SET proc_end=NOW() WHERE pid=555";
$result = $link->query($query);

$link->close();
echo '<br />FINISHED!<br />';
}


Problem is because proc_start and proc_end fields end up with a SAME value(timestamp) in DB, even I did set pause for 10 seconds.

If I use PHP's time() function instead NOW() then all is well, but I wana use NOW()...

Help Please, why does it behave that way?