[Solved] Add UPDATE into existing SELECT script

Databases
13

I managed to fix it :smile:

MODIFIED is the timestamp column.

$mysqli->query(“UPDATE events_test SET HITS = HITS + 1, MODIFIED = MODIFIED WHERE ID = $id”);

This updates the hits but ignores the timestamp.

Does this seem correct?

I also ran the other script checking both INSERT and UPDATE after changing JSON then viewed and ran the UPDATE HITS… Perfect!!!

Thanks guys :sunglasses:

Barry