Every second line

admin

Administrator
Staff member
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&nbsp;</td>
<td>varchar(50)&nbsp;</td>
<td>&nbsp; </td>
<td>Yes&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr bgcolor="#CCCCCC">
<td>Product_id&nbsp;</td>
<td>varchar(25)&nbsp;</td>
<td>&nbsp; </td>
<td>No&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr bgcolor="#DDDDDD">
<td>Type&nbsp;</td>
<td>varchar(20)&nbsp;</td>
<td>&nbsp; </td>
<td>Yes&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr bgcolor="#CCCCCC">
<td>Mfg&nbsp;</td>
<td>varchar(15)&nbsp;</td>
<td>&nbsp; </td>
<td>Yes&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr bgcolor="#DDDDDD">
<td>Description&nbsp;</td>
<td>varchar(255)&nbsp;</td>
<td>&nbsp; </td>
<td>No&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr bgcolor="#CCCCCC">
<td>Cost&nbsp;</td>
<td>decimal(5,2)&nbsp;</td>
<td>&nbsp; </td>
<td>Yes&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</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>
 
Back
Top