select * from water where id = #id#
update water
set
good = 'true'
where id = #id#
Thank You, your payment has been accepted:
Account no: #trans_id#
Amount: £#numberformat(booking.amount, 99999999.99)#
Name: #booking.bill_name#
Address:
#booking.house_name#
#booking.road#
Alderney
#booking.bill_post_code#
Email Address: #booking.bill_email#
Telephone: #booking.bill_tel#
Regards,
States of Alderney
Online Water Payment
update water
set
good = 'false'
where id = #id#
INSERT INTO
water (trans_id,amount,bill_name,house_name,road,bill_country,bill_post_code,bill_tel,bill_email,dt,interprot)
values
('#trans_id#','#amount#','#bill_name#','#house_name#','#road#','Alderney','#bill_post_code#','#bill_tel#','#bill_email#',#now()#,'#remote_addr#')
select max(id) as theone from water