Topic: [SOLVED] MySQL insert problem

[gs]

Hi, I really need some help with this, Ive been trying to figure it out for such a long time!

Ok, I want this to connect to the database, and then insert info into the table, which I already have created. Here is the exact script:

<?php

$username = $_COOKIE['ID_my_site'];
$msg = $_POST['message'];
$to = $_POST['to'];


mysql_connect("freshsql.com","username","password")or die("SQL Error".mysql_error());;
mysql_select_db("data1")or die("SQL Error".mysql_error());;

$query="INSERT INTO messages(username,from,message) VALUES('$to',$username','$msg')";
mysql_query($query)or die("SQL Error".mysql_error());


?>

It keeps returning an error:

"SQL ErrorYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''messages'(username,from,message) VALUES('gs',gs','gsaafd')' at line 1"

Please help! I cannot figure this out, Thanks
-GS


EDIT:
Use meaningful topic subject names and post in the correct forum.

[toplay]

Change this:

$query="INSERT INTO messages(username,from,message) VALUES('$to',$username','$msg')";


To this:

$query="INSERT INTO messages(`username`,`from`,`message`) VALUES('$to','$username','$msg')";

[gs]

Yes!!! It worked! Thank you VERY much! I have been trying to figure this out for SOOO LONG! Thanks very much!