I need to make time difference of 24 hours from registed time.
In my database, there is column datelog with type "timestamp" Default value: CURRENT_TIMESTAMP
I need the result if user with data:
2012-10-02 14:51:41 Test1 Test 2
User must not be able to register for next 24 hours.
Thanks in advanced.
$now = date("datelog");
$one_day = ($now -(60*60*24)); // I want to make sure of 1 day time difference
$query = "SELECT * FROM `Humeur_log` WHERE `prenom` = '".$prenom."' AND `nom` = '".$nom."' AND (`datelog` > $one_day)";