[RESOLVED] syntax problem with insert query

[andy_wang]

i use apache php mysql on my pc, and version of php is 5.2.6.
this is driving me crazy, it works when i changed table name "post" to "message", which is another table that has the same setting in mysite database. but it does not work with "post" table, any one can help, pls?

many thanks in advance

here is my code:
---------------------connection.php-------------
<?php
$connection=mysql_connect("localhost","root","") or die("fail to connet database!".mysql_error());
mysql_select_db("mysite",$connection) or die("fail to connet database!".mysql_error());
?>
---------------------end--------------------------

<?php include("../accessory/connection.php"); ?>
<?php
session_start();
if($_SESSION["username"]=="")
{
	echo "<script>window.location='../index.php';alert('login pls!');</script>";
	exit;
}
else
{
	$name = $_SESSION["username"];

$subject = $_POST[subject];

$title = $_POST[title];

$limit = $_POST[limit];

$content = $_POST[content];

$mysql = mysql_query("insert into post (name,subject,title,limit,content) values ('$name','$subject','$title','$limit','$content')",$connection);
echo "<script>window.location='createpostdone.php';alert('done');</script>";

}
?>

i have tested those variables with alert function, they all have values. it's strange😕😕

[scrupul0us]

whats the error?

and just a security minder... dont use ROOT for your connections... make an account that only has, select, update, insert, delete permissions

[andy_wang]

hi, thank you for your reply, i did what you said. but it still does not work at all.
actaully, there is not error message, the system dsiplays "done" after execution. Even i have tested those ($name,$subject,$title,$limit,$content)variables with alert function, they all have values.

it works when i changed table name "post" to "message", which is another table that has the same setting in "mysite" database. but it does not work with "post" table. just insert query doesnt work, i couldnt understand why.

is the "post" kind of name we can't use as table name?

cheers

[andy_wang]

well, i finally figer it out why the code does not work.

because mysql doesn't support "limit" as a column name&#65292; what a unexpected reason, i spent whole day in it.

pls dont make the same mistake as i do!