I need a MySQL query that adds 1 day to the exact date and time that the PHP script was executed.
It needs to update the table users and pick the row where user_id=$uid, then find the column expiry_datetime and set it to exact date and time the php script was executed, + 1 day.
All the current entries in the table are 0000-00-00 00:00:00
Everything I have tried has not even come close to working, does anyone know the best way of doing this?