How to convert .txt file into MySQL
Good Day Everybody,
I'm am designing online store. My supplier is giving product information (images, product description, prices etc) in .txt file. The list is more than 9,000 long.
How can I convert this information into MySQL and retrieve data whenever user clicks product for purchase, since my online store will be a dynamic site.
I need to update the list almost daily as inventory from the supplier changes often.
I need distinguished forum members' advice on this very basic question.
NOTE: I'm new to site design and development and Sitepoint's books have been really helpful in guiding me thus far.