auto_increment making extra row?

floppydrivez · 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')");

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

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

floppydrivez · 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?

fkelly · 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.

floppydrivez · 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.

montego · 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.