Ok, so I have a massive file of information, now FIND AND REPLACE techniques do not work, so making a PHP script, should. Now I have the information like so (exactly how it is in the file)
id<br>
name<br>
title<br>
album<br>
year<br>
id<br>
name<br>
title<br>
album<br>
year<br>
id<br>
name<br>
title<br>
album<br>
year<br>
So on and so forth for about 4,500 times. (Obviously the values are set in the text file though). Now I am wondering how will I go about putting it into my database? I know how to insert:
mysql_query("INSERT INTO listings VALUES('','','','','')");
But not sure how to make my text file do it in the format it is in.
I need to find a solution by tommorow morning at the latest, any ideas please??
Note 1: The <br> tags are in the file.
Note 2: The insert command will insert the information from every 5 lines.