INSERT INTO res_collections (company,city,state,active)
VALUES ('#form.company#','#form.city#','#form.state#',#form.active#)
UPDATE res_collections
SET
company = '#form.company#',
city = '#form.city#',
state = '#form.state#',
active = #form.active#
WHERE ID = #URL.ID#
SELECT *
FROM res_collections
Admin: Main Page