I inserted a text file with phpMyAdmin and only every second line will go in.
<table border=0>
<tr>
<th>Field</th>
<th>Type</th>
<th>Attributes</th>
<th>Null</th>
<th>Default</th>
<th>Extra</th>
</tr>
<tr bgcolor="#DDDDDD">
<td>Note </td>
<td>varchar(50) </td>
<td> </td>
<td>Yes </td>
<td> </td>
<td> </td>
</tr>
<tr bgcolor="#CCCCCC">
<td>Product_id </td>
<td>varchar(25) </td>
<td> </td>
<td>No </td>
<td> </td>
<td> </td>
</tr>
<tr bgcolor="#DDDDDD">
<td>Type </td>
<td>varchar(20) </td>
<td> </td>
<td>Yes </td>
<td> </td>
<td> </td>
</tr>
<tr bgcolor="#CCCCCC">
<td>Mfg </td>
<td>varchar(15) </td>
<td> </td>
<td>Yes </td>
<td> </td>
<td> </td>
</tr>
<tr bgcolor="#DDDDDD">
<td>Description </td>
<td>varchar(255) </td>
<td> </td>
<td>No </td>
<td> </td>
<td> </td>
</tr>
<tr bgcolor="#CCCCCC">
<td>Cost </td>
<td>decimal(5,2) </td>
<td> </td>
<td>Yes </td>
<td> </td>
<td> </td>
</tr>
</table>
<br>
<table border=0 bgcolor="#DDDDDD">
<tr>
<th>Keyname</th>
<th>Unique</th>
<th>Field</th>
</tr>
<tr>
<td>PRIMARY</td>
<td>Yes</td>
<td>Product_id</td>
</tr>
</table>
Field Type Attributes Null Default Extra
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 -<br>
"$ Change" "ICA7D-800" "C.P.U." "AMD" "Duron? 800 - 128K 200 FSB Socket A w/ Fan - OEM" "86.00"<br>
"$ Change" "ICA7D-850" "C.P.U." "AMD" "Duron? 850 - 128K 200 FSB Socket A w/ Fan - OEM" "91.00"<br>
"$ Change" "ICA7D-900" "C.P.U." "AMD" "Duron? 900 - 128K 200 FSB Socket A w/ Fan - OEM" "100.00"<br>
"$ Change" "ICA7D-950" "C.P.U." "AMD" "Duron? 950 - 128K 200 FSB Socket A w/ Fan - OEM" "118.00"<br>
"$ Change" "ICA7P-900" "C.P.U." "AMD" "Athlon?900 - (Thunderbird) Socket A w/ Fan - OEM" "108.00"<br>
<br>
- From MySql DB -<br>
$ Change ICA7D-800 C.P.U. AMD Duron?800 - 128K 200 FSB Socket A w/ Fan - OEM 86.00<br>
$ Change ICA7D-900 C.P.U. AMD Duron?900 - 128K 200 FSB Socket A w/ Fan - OEM 100.00<br>
$ Change ICA7P-900 C.P.U. AMD Athlon?900 - (Thunderbird) Socket A w/ Fan - OEM 108.00<br>
<table border=0>
<tr>
<th>Field</th>
<th>Type</th>
<th>Attributes</th>
<th>Null</th>
<th>Default</th>
<th>Extra</th>
</tr>
<tr bgcolor="#DDDDDD">
<td>Note </td>
<td>varchar(50) </td>
<td> </td>
<td>Yes </td>
<td> </td>
<td> </td>
</tr>
<tr bgcolor="#CCCCCC">
<td>Product_id </td>
<td>varchar(25) </td>
<td> </td>
<td>No </td>
<td> </td>
<td> </td>
</tr>
<tr bgcolor="#DDDDDD">
<td>Type </td>
<td>varchar(20) </td>
<td> </td>
<td>Yes </td>
<td> </td>
<td> </td>
</tr>
<tr bgcolor="#CCCCCC">
<td>Mfg </td>
<td>varchar(15) </td>
<td> </td>
<td>Yes </td>
<td> </td>
<td> </td>
</tr>
<tr bgcolor="#DDDDDD">
<td>Description </td>
<td>varchar(255) </td>
<td> </td>
<td>No </td>
<td> </td>
<td> </td>
</tr>
<tr bgcolor="#CCCCCC">
<td>Cost </td>
<td>decimal(5,2) </td>
<td> </td>
<td>Yes </td>
<td> </td>
<td> </td>
</tr>
</table>
<br>
<table border=0 bgcolor="#DDDDDD">
<tr>
<th>Keyname</th>
<th>Unique</th>
<th>Field</th>
</tr>
<tr>
<td>PRIMARY</td>
<td>Yes</td>
<td>Product_id</td>
</tr>
</table>
Field Type Attributes Null Default Extra
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 -<br>
"$ Change" "ICA7D-800" "C.P.U." "AMD" "Duron? 800 - 128K 200 FSB Socket A w/ Fan - OEM" "86.00"<br>
"$ Change" "ICA7D-850" "C.P.U." "AMD" "Duron? 850 - 128K 200 FSB Socket A w/ Fan - OEM" "91.00"<br>
"$ Change" "ICA7D-900" "C.P.U." "AMD" "Duron? 900 - 128K 200 FSB Socket A w/ Fan - OEM" "100.00"<br>
"$ Change" "ICA7D-950" "C.P.U." "AMD" "Duron? 950 - 128K 200 FSB Socket A w/ Fan - OEM" "118.00"<br>
"$ Change" "ICA7P-900" "C.P.U." "AMD" "Athlon?900 - (Thunderbird) Socket A w/ Fan - OEM" "108.00"<br>
<br>
- From MySql DB -<br>
$ Change ICA7D-800 C.P.U. AMD Duron?800 - 128K 200 FSB Socket A w/ Fan - OEM 86.00<br>
$ Change ICA7D-900 C.P.U. AMD Duron?900 - 128K 200 FSB Socket A w/ Fan - OEM 100.00<br>
$ Change ICA7P-900 C.P.U. AMD Athlon?900 - (Thunderbird) Socket A w/ Fan - OEM 108.00<br>