Import text to mysql question...

Hi guys, I need to import a single field into a mysql table from
a text file. Namely, what I need is this:

MySql Table = mdrecord
Field = regnumber

Text document is structured as follows:

0111245-554,
0111246-554,
.
.
.
0111301-554,

They are in no particular order and have comma delimiters
and hard return.

Would appreciate any help, I've tried searching but cannot find
any insight into this.

Thanks,
wl. 😕

use the explode() function.

example.

$line1 = "a,b,c,d,e,f";

$chr = explode(",", $line1);

for($i=0; $i<count($chr); $i++)
 INSERT INTO TABLE(COLUMN1) VALUES ($chr[$i]);

Thanks for your reply shawon22. Would you be so kind as to
break down the code for me, I'm new to PHP and seem to be
lost here.

On $line1, is this where I would mention the file name I want
to process or does "a,b,c,d,e,f" serve a specific function?

Thanks again.
wl