UPDATE banners_history set banners_history.banners_clicked = banners_history.banners_clicked + 1 where banners_history.banners_id = AND date_format(banners_history.banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')