hi,
my php/ mysql query code does not insert data to my table and prints out an error. pls help ive been at this for hours without figuring out what's wrong.
my code:
<?php
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("fppms") or die(mysql_error());
mysql_query("INSERT INTO employee record(Employee ID, Employee type, First name, Last name, Farm location, Farm type) VALUES('34', 'caretaker', 'Michael', 'Hipolito', 'lara', 'nursery' )")
or die(mysql_error());
echo "Data Inserted!";
?>
mysql error message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'record(Employee ID, Employee type, First name, Last name, Farm location, Farm ty' at line 1
any help will be appreciated. thanks