[Resolved] problems iserting into mysql

[chriswheat]

Hello,

I have a table named raffle in my data base and in that table I have 7 fields
raffleid int auto_incrimet
girlname
tkt_amount
tkt_start
tkt_sold
status
winner

When I try to use the following code I get a syntax error, have looked and looked cannot figure our the problem heres the code

include ("db_connection.php");
$girlname = $POST["girlname"];
$tkt_amount = $POST["tkt_amount"];
$tkt_start = $_POST["tkt_start"];
mysql_query("INSERT INTO raffle (girlname, tkt_amount, tkt_start,)
VALUES('$girlname','$tkt_amount','$tkt_start', now())") or die (mysql_error());
print "<p>$girlname<p>$tkt_amount<p>$tkt_start";

here is the error:
You have an error in your SQL syntax near ') VALUES('Test Bull','25.00','150', now())' at line 1

Many thanks ,
Chris Wheat

[sid]

theres a comma too much... it must be like this:

mysql_query("INSERT INTO raffle (girlname, tkt_amount, tkt_start) 
VALUES('$girlname','$tkt_amount','$tkt_start', now())") or die (mysql_error());