INSERT data into database
Posted: Sat Mar 31, 2012 11:10 pm
Hi guys, i've been trying to insert data into my database but i keep getting this error:
Below is my code. I can't figure out where it went wrong.. can someone point it out to me please? thanks..Error: 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 'procedure,date) VALUES ('tag1','new post','01/04/12 02:55:34')' at line 1
Code: Select all
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// get data that sent from form
$tags=$_POST['tags'];
$procedure=$_POST['tulis'];
$datetime=date("d/m/y h:i:s"); //create date time
$sql="INSERT INTO $tbl_name(tags,procedure,date) VALUES ('$tags','$procedure','$datetime')";
$result=mysql_query($sql);
if($result){
echo "Successful<BR>";
}
else {
echo "Error: " . mysql_error()."<br>";
}
mysql_close();