MySQL error 1064

[NeoMaul]

Can someone please help me with this error? I'm still sorta new to this stuff.

I am trying to build a newscript and it works except whenever you try and add a ' into the news posting it won't add the entire post to the db.

it says the error is;

MySQL error 1064: You have an error in your SQL syntax near 'neo', now())' at line 2

(neo is the value for the author variable)

$query = "INSERT INTO news(title, news, author, date)
VALUES('".$_POST['title']."','".$_POST['news']."','".$_POST['author']."', now())";
mysql_query($query);

thanks in advance for any help 🙂

[mysql_query]

the mysql_query structure is like this:

mysql_query($query, $db);

where $db is the name of your database.

Hope this helps.

[NeoMaul]

Hrmm, thanks but...

you have solved the error, (it says 0 errors now) except that it still won't add the news post to the database. It completes the if statement and says that the news item has been added, but when I go to check it hasn't 🙁

this only happens when I add the character ' into my news item. If you don't use ' at all then it will add it to the database quite fine with no problems at all. I just don't understand why :/

btw thanks for your help so far.

anymore ideas? anyone?