Hi, I have a text file and want to update the records in mysql database based on the records in the text file. I have attached the txt file. It has fields separated by | and i can't get how to access the fields. Awaiting for some help. Thanks
You'd have to write a script (e.g. with PHP) that parses the script and create MySQL INSERT statements of it. Take a look at PHP's explode() function: http://de.php.net/manual/en/function.explode.php
Really nice link . All most darshanpm's quire will be resolve , because in above link all the description giving with particular coding and instruction . Most i liked that giving all instruction for both version PHP4 and PHP5 .