Code: Select all
"INSERT INTO people
(person_id,org_id, salutation,
firstname, surname, organisation, role,
address1, address2, city, postcode, telephone,
mobile, fax, dateoflastcontact, datecontactagain,
notes, email)
VALUES
('$person_id','$org_id','$salutation',
'$firstname','$surname', '$organisation',
'$role', '$address1', '$address2', '$city',
'$postcode', '$telephone', '$mobile', '$fax',
'$dateoflastcontact', '$datecontactagain',
'$notes', '$email')
DATE_FORMAT(dateoflastcontact, '%d/%m/%y')
AS dateoflastcontact, DATE_FORMAT(datecontactagain, '%d/%m/%y')
AS datecontactagain
";
ї\code]