INSERT with subquery error

[andyt683]

In table 1, we have a "defaults" table. When a user creates a new instance, the defaults are copied into a "running" table, with their ID and the instance # attached, along with all the data from the defaults table. The instance is then run from the "running" table. Thats the theory, at least.

 

$uniqid is a static number, an amalgam of the users' ID and the instance ID.

 

INSERT INTO `mission_run` (`instance_id`,`id`,`x`,`y`,`owner`,`passable`,`soldiers`) VALUES('$uniqid', (SELECT `id`,`x`,`y`,`owner`,`passable`,`soldiers` FROM `mission_start` WHERE `id` = '1' ORDER BY x ASC, y ASC))

 

MySQL said:

 

Column count doesn't match value count at row 1

 

SELECTING `id`,`x`,`y`,`owner`,`passable`,`soldiers` FROM `mission_start` WHERE `id` = '1' returns the following data:

id    x    y    owner    passable    soldiers

1 0 6 0 0 0

1 0 7 0 0 0

1 0 5 0 0 0

 

Any ideas?

[teng84]

i guess the field where you are trying to supply a value is greater that the number of those values or vise versa

[andyt683]

Aside from the instance_id column, each table is identical.

[fenway]

Um, the # of insert cols doesn't match the # of select cols... count again.