auto_increment making extra row?

Posted: Thu Sep 14, 2006 10:07 am

When I insert my row of info its adding a row of blanks Very Happy

with its own id.

Did I format any of this wrong?

Code:

CREATE TABLE nuke_league_games (


   gid int NOT NULL auto_increment,


   PRIMARY KEY (gid),


   gname text NOT NULL,


   version text NOT NULL,


   gabbr text NOT NULL


) TYPE=MyISAM;

Code:




$addgame = $db->sql_query("INSERT INTO ".$prefix."_league_games VALUES (null, '$gtitle','$version','$abrev')");

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

Looks OK. Usually the primary key field is defined after the fields on the create statement.

Posted: Thu Sep 14, 2006 10:37 am

Yeah, I changed it to see if that made a difference. Any idea why I get a extra row with nothing defined except the gid?

Posted: Thu Sep 14, 2006 11:23 am

You are defining gid as not null and then sticking null in it for one thing.

I'd stick a 1 in it.

Posted: Thu Sep 14, 2006 12:03 pm

This makes sense plus it works.

Code:

$addgame = $db->sql_query("INSERT INTO ".$prefix."_league_games VALUES ('', '$gtitle','$version','$abrev')");

I tried it without the

Code:

''

My result was an error.

registered · Posted: Fri Sep 15, 2006 7:20 am

floppydrivez, I used your original CREATE statement from above to create the table and then I tried this exact INSERT statement:

INSERT INTO nuke_league_games VALUES (null, 'title','version','abrev');

It inserted just fine and only 1 row. I believe that you may have had an issue with how your variables were getting defined/valued and that it had nothing to do with the actual SQL.