gahhh!!!

[roy]

$sql = "INSERT into links VALUES ('$lname','$ldesc','$lurl')";
$sql_result = mysql_query($sql,$connection) or die ( mysql_error() );
echo('Data inserted corectly');
mysql_close($connection);

if i do INSERT into links (column1,column2,column3)

i will get an error message:

You have an error in your SQL syntax near 'desc,url) VALUES ('awef','awefwww','waefwaf')' at line 1

HOWEVER, if i simply do INSERT into links without the columns listed (as abvove), the data inserts without a problem.

what's the problem?

[sgoku01]

Try this:

sql = "INSERT into links (name, order, link) VALUES ('$lname','$ldesc','$lurl')";

Change name, order and link into the names of the fields where the values should be inserted in...

[roy]

oops, i wasn't very clear in my first post.

$sql = INSERT into links (name, desc, url) VALUES ('$lname','$ldesc','$lurl')";

is what i do, and i get the error:
You have an error in your SQL syntax near 'desc,url) VALUES ('awef','awefwww','waefwaf')' at line 1

However, if I do:

$sql = INSERT into links VALUES ('$lname','$ldesc','$lurl')";

i get no errors. and those are the only three columns ...

not sure the post above answers my question now🙁

[xblue]

rename your column desc.

desc is a reserved word in mysql, but unfortunately it is so tempting to use it as abbreviation for description (at least that's what I did that once, too) 😉

[roy]

so apparently mysql doesn't like a table named 'names.' the moment i changed it to 'lnames' everything worked alright.

are there specific limitations on what you can name tables in mysql?

[xblue]

http://www.mysql.com/doc/en/Reserved_words.html

[roy]

i don't see 'names' on that list?

[xblue]

names is not a reserved word, but desc is.