> These SPs will check the field date value against the current date.
> However I see a big security hole: normal users could change the PC
> date and modify whatever row they want.
> Is there any better solution ?
Maybe if you compare against the max_date entered, i.e.
instead of: if (new.date > current_timestamp)
use: if (new.date > (select max(date_field) from table).