Why this error

phpn00bf4life

<html>
<?php
$connect=mysql_connect("localhost","waradmn_waradmn","****") 
                                    or die("could not connect to mysql");
mysql_select_db("waradmn_lnks1",$connect)
                                    or die("could not choose database: waradmn_lnks1");
$query = mysql_query"INSERT INTO chat ("id","post_author","post_date","post_content") VALUES ("NULL","$author","NULL","$content")";

echo "Thanks!  <a href="www.wargamershq.com/chat.php>return to shout</a>";
?>
</html>

i Get a error message that line 7 is invalid...why? what's wrong witht the script?

phpn00bf4life

k fixed that...but now i get this 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 ''id','post_author','post_date','post_content') VALUES ('','',''

scorpioy

normally that syntax error comes from the mismatch of the data you are trying to insert and number of table column or column data type

tsinka

Hi,

remove the single quotes in

('id','post_author','post_date','post_content')

Additionally, it seems like the variables you use in the SQL query not being set. Are they coming from a form ? In that case you might need to use $POST['variable'] (post variables) or $GET['variable'] (get variables).

Thomas