Hi all,
I have been searching forums
It starts just after my INSERT statement. 6944 is the name of the table I'm inserting into....
Notice: 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....
'6944 (username, player1, player2, player3, player4, player5, player6, player7, p' at line 1
INSERT INTO 6944 (username, player1, player2, player3, player4, player5, player6, player7, player8, player9, player10, player11, player12, player11, player14) VALUES ('Tpowell04', 'asdfasdf', 'asdfasdf', 'asdfasdfa', 'sdfasdf', 'asdfasdfa', 'sdfasdf', 'asdfasdfas', 'fasfasf', 'asdfasf', 'asdfasfas', 'fasfasfas', 'fasdfasdfa', 'sdfassdfadfasdfasdf', 'aasdfasdf') in
Here is the code:
<?php
//connect to DB
$username = "xxxxx";
$password = "xxxxx";
$hostname = "p50mysql.....";
$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
if (!$dbh)
{
die('Could not connect: ' . mysql_error());
}
else echo ("Looks good!");
//gather form data
$player1 = $POST["player1"];
$player2 = $POST["player2"];
$player3 = $POST["player3"];
$player4 = $POST["player4"];
$player5 = $POST["player5"];
$player6 = $POST["player6"];
$player7 = $POST["player7"];
$player8 = $POST["player8"];
$player9 = $POST["player9"];
$player10 = $POST["player10"];
$player11 = $POST["player11"];
$player12 = $POST["player12"];
$player13 = $POST["player13"];
$player14 = $POST["player14"];
mysql_select_db("Tpowell04", $dbh);
//actual query
$query = "INSERT INTO 6944 (username, player1, player2, player3, player4, player5, player6, player7, player8, player9, player10, player11, player12, player11, player14)
VALUES ('$username', '$player1', '$player2', '$player3', '$player4', '$player5', '$player6', '$player7', '$player8', '$player9', '$player10', '$player11', '$player12', '$player13', '$player14')";
$result = mysql_query($query);
$result = mysql_query($query);
if(!$result)
{
user_error(mysql_error() . "<br />\n$query");
}
?>
