[Resolved] Any Way to do this with php?

build

Hi all

I have made a data base for php

Which all works fine

I made a new data base and then went to export the old data base into my new data base and came up with a error
Useing phpmyadmin

Paste in the big box INSERT INTO category VALUES (84, 'out side', 0);

11.....Errors come up like

Database new27 - table category running on localhost
Error
SQL-query :
INSERT INTO category
VALUES ( 84, 'out side', 0 )
MySQL said:
Column count doesn't match value count at row 1

I did a search on the net for this error and found out that I had to add to my old data base three more columns and just called them test 1 test2 test 3

Then exported then import back into my new data base.

Is there a better way to do this or is it ok how I have done it?

As always, any and all help is greatly appreciated.

Thank you in advance.

John

barand

If you are doing an sql insert, it is better to be specific about the columns names.

INSERT INTO category (fieldname1, fieldname2, fieldname2)
VALUES ( 84, 'out side', 0 )

This way it doesn't matter if your table actualy has more fields than the value clause. It also gives you future-proofing to some extent, extra fields can be added to the table, or the field order in the yable can be physically altered, at a later date without you having to change your code.

hth

build

Hi Barand

Thank you very much for your help

I'm I bit confused

The below is how I have got it set up (well just one table ) did not want to put all the tables on here

Old data base category
Field Type null default
id smallint(5) No

name varchar(100) No

parentid smallint(5) No 0

New data base

Field Type null default
id smallint(5) No

name varchar(100) No

pid smallint(5) No 0

fset varchar(255) No

weight tinyint(3) No 0

image varchar(255) No

descr text No

========================================

Dumping data for table `category`

#
INSERT INTO category VALUES (84, 'out side', 0);
INSERT INTO category VALUES (79, 'test2', 0);
INSERT INTO category VALUES (91, 'test3', 0);
INSERT INTO category VALUES (84, 'test4', 0);
INSERT INTO category VALUES (78, 'test5', 0);
INSERT INTO category VALUES (71, 'test6', 0);

So from what you are saying
INSERT INTO category (fieldname1, fieldname2, fieldname2)
VALUES ( 84, 'out side', 0 )

Have I go this right

INSERT INTO category (id, name, pid)
VALUES ( 84, 'out side', 0 )
VALUES (79, 'test2', 0);
VALUES (91, 'test3', 0);
VALUES (84, 'test4', 0);
VALUES (78, 'test5', 0);
VALUES (71, 'test6', 0);

I get a error saying "you have a error in your sql syntax near 'Value (79,'test2',0)' at line 1

Try as I can I cannot see where it is. 🙂)

regards

John

barand

Like this

INSERT INTO category (id, name, pid) VALUES ( 84, 'out side', 0 );
INSERT INTO category (id, name, pid) VALUES (79, 'test2', 0);
INSERT INTO category (id, name, pid) VALUES (91, 'test3', 0);
INSERT INTO category (id, name, pid) VALUES (84, 'test4', 0);
INSERT INTO category (id, name, pid) VALUES (78, 'test5', 0);
INSERT INTO category (id, name, pid) VALUES (71, 'test6', 0);

build

Hi Barand

Oh dear me so simple , I feel such a fool.

It worked just fine

Thank you for your help

Regards

John