Problems with Add Code

[olly2111]

I want to add something to a database using a file instead of ftp.
The following code excutes fine, however nothing is created in the database.
The database names are correct.
Any ideas?

[laserlight]

$sql = "INSERT INTO $table SET
              item = '$item',";

this is invalid SQL.

[HalfaBee]

Just to clarify our Junior Members post, ( 🙂 ) the comma is not needed on the end of the query.

HalfaBee

[olly2111]

oh yea oops.
My blind mistake :/

[olly2111]

it still doesnt work even without the ,

$sql = "INSERT INTO $table SET
              item = '$item'";
	$result = mysql_query($query);

[olly2111]

nevermind, my mistake