People - SQL

UPDATE People SET fname = '#Form.fname#', lname = '#Form.lname#', age = #Form.age# WHERE pID = #Form.pID# INSERT INTO People (fname, lname, age) VALUES ('#Form.fname#', '#Form.lname#', #Form.age#)

All People

SELECT * FROM People ORDER BY lname, fname

#getPeople.fname# #getPeople.lname#, age #getPeople.age#

Add Person

Edit Person

SELECT * FROM People WHERE pID = #URL.person_to_edit#