[SOLVED] ERROR PLEASE HELP

[paulman888888]

I have made my code but i get an error. Below is my code.

<?php
$ip = $_SERVER['REMOTE_ADDR'];
$today = date("m.d.y");
$time = time("H"); 
// Insert a row of information into the table "myscore2"
mysql_query("INSERT INTO myscore2 
(name, score, gameid, mode, thedate, thetime, ) VALUES('" . mysql_real_escape_string(substr($_GET['name'], 0, 13)) . "', '" . mysql_real_escape_string($_GET['score']) . "', '" . mysql_real_escape_string($_GET['gameid']) . "', '" . mysql_real_escape_string($_GET['mode']) . "', '" . mysql_real_escape_string('{$today}') . "', '" . mysql_real_escape_string('{$time}') . "', '" . mysql_real_escape_string('{$ip}') . "', )") 
or die(mysql_error());  
echo "Score Uploaded!#";
?>

and 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 ') VALUES('testing1111', '9999', '444', '1', '{$today}', '{$time}

 

What am i doing wrong?

 

Thankyou

[almightyegg]

mysql_query("INSERT INTO myscore2 
(name, score, gameid, mode, thedate, thetime) VALUES('" . mysql_real_escape_string(substr($_GET['name'], 0, 13)) . "', '" . mysql_real_escape_string($_GET['score']) . "', '" . mysql_real_escape_string($_GET['gameid']) . "', '" . mysql_real_escape_string($_GET['mode']) . "', '" . mysql_real_escape_string('{$today}') . "', '" . mysql_real_escape_string('{$time}') . "', '" . mysql_real_escape_string('{$ip}') . "')") 
or die(mysql_error());  

 

Try that

[paulman888888]

what have you changed?

[revraz]

The error is coming from the Comma after thetime

[almightyegg]

And the comma after the last value. Just copy and past that it and see if you get any more errors

[paulman888888]

thankyou guys so much. It works.