Only every second line

admin

Administrator
Staff member
I inserted a text file from phpMyAdmin into the following table with the following results (namely that it inserts every second line. With 365 lines in the file and 183 records being inserted).

Can anybody please tell me what I've done wrong?! :o

- Table Sturcture -
- Field / Type / Null -
Note / varchar(50) / Yes
Product_id / varchar(25) / No
Type / varchar(20) / Yes
Mfg / varchar(15) / Yes
Description / varchar(255) / No
Cost / decimal(5,2) / Yes

- From Text File -
"$ Change" "ICA7D-800" "C.P.U." "AMD" "Duron?800 - 128K 200 FSB Socket A w/ Fan - OEM" "86.00"
"$ Change" "ICA7D-850" "C.P.U." "AMD" "Duron?850 - 128K 200 FSB Socket A w/ Fan - OEM" "91.00"
"$ Change" "ICA7D-900" "C.P.U." "AMD" "Duron?900 - 128K 200 FSB Socket A w/ Fan - OEM" "100.00"
"$ Change" "ICA7D-950" "C.P.U." "AMD" "Duron?950 - 128K 200 FSB Socket A w/ Fan - OEM" "118.00"
"$ Change" "ICA7P-900" "C.P.U." "AMD" "Athlon?900 - (Thunderbird) Socket A w/ Fan - OEM" "108.00"

- From MySql DB -
$ Change ICA7D-800 C.P.U. AMD Duron?800 - 128K 200 FSB Socket A w/ Fan - OEM 86.00
$ Change ICA7D-900 C.P.U. AMD Duron?900 - 128K 200 FSB Socket A w/ Fan - OEM 100.00
$ Change ICA7P-900 C.P.U. AMD Athlon?900 - (Thunderbird) Socket A w/ Fan - OEM 108.00
 
Back
Top