MySQL INSERT Problems

mharris

Here is my PHP:

<?
//Tour-a-Trak System
//Version 0.1 BETA
//Mark Harris (hadmharris@adelphia.net)
//New Team creation script, writes from file to MySQL dbase
if ((!$Name)||(!$School)||(!$Ident)||(!$NumPlay)||(!$Pool)||(!$Contact))
{
        header("Location:NewTeam.htm");
        exit;
}
$dbname= "CP";
$table_name= "Teams";
$connection = @mysql_connect("localhost", "simconse","qria12") or
        die("Couldn't Connect to Database");
$db = @mysql_select_db($dbname, $connection) or
        die("Couldn't select Database");
$sql = "
        INSERT INTO $table_name
        (ID, Name, School, CODE, Pool, W, L, PF, PA, Contact)
        VALUES
        (\"\", \"$Name\",\"$School\",\"$Ident\",\"$Pool\",0,0,0,0,\"$Contact\")
        ";
$result = @mysql_query($sql,$connection)
        or die ("Couldn't Execute Query.");
?>

<HTML>
<HEAD>
<TITLE>Adding a New Team</Title>
</HEAD>
<BODY>
<H1> Adding a Record to <? echo "$table_name";?></H1>
<H3>
Name: <? echo "$Name";?><br>
School: <? echo "$School";?><br>
Identifier: <? echo "$Ident";?><br>
Pool: <? echo "$Pool";?><br>
Contact: <? echo "$Contact";?><br>
<form method="POST" action="BuildRoster.php">

  

<?
  for ($x=0; $x<$NumPlay; $x++)
  {
  echo "<p>First Name: <input type=\"text\" name=\"FName[$x]\" size=\"20\" tabindex=\"1\">&nbsp;
  Last Name: <input type=\"text\" name=\"LName[$x]\" size=\"20\" tabindex=\"2\">&nbsp;
  Grade: <input type=\"text\" name=\"Grade[$x]\" size=\"5\" tabindex=\"4\">
  Jersey Number: <input type=\"text\" name=\"JNum[$x]\" size=\"5\" tabindex=\"5\"></p>";
  }
  ?>

Ok and when I echo I get this:
INSERT INT Players(ID,FName,LName,Team,Grade,Asst,Goals,JNum) VALUES ("","Mark","Harris","JBS",12,0,0,3)

My MySQL Format is as follows:
ID-INT-auto_increment
FName-Varchar
LName-Varchar
Team-Varchar
Grade-Int
Asst-Int
Goals-Int
JNum-Int

I know I am probably making an easy mistake but can't find it.

jweissig

hi,

i don't want to read all your code and find all the error's! Can you just give me a fast rundown of what is happening and then i can find out why. Basially i want to know what you are expecting and what the script is doing.

Justin

mharris

Well the script should be inserting entries (multiple players) into a Players table. But it doesn't work for some reason. The SQL will not actually insert into the table, and I am not sure why

jweissig

hi,

try and remove the "insert -> ID" thing.. what seems to be happening is you are attempting to insert a number or NULL into a autonumber field..

try this. "insert into table_name (field1, field2, etc) values (field1, field2, etc.);" and remove the ID thing completly! this should solve the problem.

please let me know how this works out!

Justin

sdkeene1

Try formatting your insert statement like this:

$sql = "
INSERT INTO $table_name
(Name, School, CODE, Pool, W, L, PF, PA, Contact)
VALUES
('$Name', '$School', '$Ident', '$Pool', 0, 0, 0, 0, '$Contact')
";

You shouldn't need to do anything for the ID field. Hope this helps.

mharris

I am having problems still. Here is the crucial part of code

$dbname= "CP";
$table_name= "Players";
$connection = mysql_connect("localhost", "simconse","qria12") or
        die("Couldn't Connect to Database");
$db = mysql_select_db($dbname, $connection) or
        die("Couldn't select Database");
for ($x=0;$x<$NumPlay;$x++)
{
$sql = "
        INSERT INTO $table_name
        (FName, LName, Team, Grade, Asst, Goals, JNum)
        VALUES
        (\"$FName[$x]\",\"$LName[$x]\",\"$CODE\",$Grade[$x],0,0,$JNum[$x])
        ";
$result = mysql_query($sql,$connection);
        //or die ("Couldn't Execute Query.");

It doesn't execute the SQL it would die out if I didn't have the "or die" comman commented out (I do this so I can see a dump of the SQL statement which looks like this
INSERT INT Players(ID,FName,LName,Team,Grade,Asst,Goals,JNum)
VALUES ("","Mark","Harris","JBS",12,0,0,3)

BigMike

Originally posted by mharris

<snips>
the SQL statement which looks like this
INSERT INT Players(ID,FName,LName,Team,Grade,Asst,Goals,JNum)
VALUES ("","Mark","Harris","JBS",12,0,0,3)

Its probably a typo, but it is the second time in this thread...
did you mean the INT to be INTO ?

Regards,

Mike