UPDATE guestlog SET date=NOW() where ID=...

##</code><code>##

SELECT cola, colb, DATE_FORMAT(date,'%d, %H:%M') FROM guestlog ORDER BY date DESC