What's wrong with my code..

[edpudol]

When I am trying to add new record to my table I got this message.

Found Error 1064: 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 ')' at line 13 Query:

This is my code:

$connection = mysql_connect("localhost","mysql","mypass");
mysql_select_db("myusername",$connection);

$sql = "SELECT * FROM table";

$result = mysql_query( $sql,$connection )or die("hMM Error ".mysql_errno().": ".mysql_error()."\nQuery: $query");

   mysql_query("INSERT INTO jobposting 
 VALUES ('company',
    '$address',
'$Country',
'$category',
'$jobtitle',
'$description',
'$contact',
'$email',
'$number',
'$website',
    '$enddate',
        )") or die("Found Error ".mysql_errno().": ".mysql_error()."\nQuery: $query");

my other script using other table with almost the same format works but this one won't.

Help please.. thanks..

[zhabala]

In you SQL stament with INSERT there is a comma after last inserted value

'$website', 
'$enddate', 
)") 

it should not be there

'$website', 
'$enddate'
)")

Zdenek

[edpudol]

Yes the code works.. thanks alot a simple problem make my head sick...