INSERT INTO show (name,date1,gallery,city,st,info,active)
VALUES ('#form.name#','#form.date#','#form.gallery#','#form.city#','#form.state#','#form.info#',#form.active#)
UPDATE show
SET
name = '#form.name#',
date1 = '#form.date#',
gallery = '#form.gallery#',
city = '#form.city#',
st = '#form.state#',
info = '#form.info#',
active = #form.active#
WHERE ID = #URL.ID#
SELECT *
FROM show
Admin: Shows
