title: Automatically import CSV file and upload to database
body: <p>One of my clients has all of his product information handled by an outside source. They have provided this to me in a CSV file which they will regulary update and upload to an ftp folder of my specification, say every week.</p>
  
  <p>Within this CSV file is all of the product information; product name, spec, image location etc.</p>
  
  <p>The site which I have built for my client is running a MySQL database, which I thought would be holding all of the product information, and thus has been built to handle all of the product data.</p>
  
  <p>My question is this: How would I go about creating and running a script that would find a newly added CSV file from the specified FTP folder, extract the data, and replace all of the data within the relevant MySQL table, all done automatically? </p>
  
  <p>Is this even possbile?</p>
  
  <p>Any help would be greatly appreciated as I don't want to use the IFrame option, S. </p>