MySQL and CSV

[schueymcfee]

I have a site that sells products, now the supplier of these products also supplies a live RSS or CSV feed to show if a product is in or out of stock.

Unfortunately they do not supply details of how to integrate this into our current shopping cart to show products as in or out of stock.

So how can I get a CSV file to update a MySQL database?

[tigger1]

"load data infile"

and then "insert into" / update. Don't know without having a little think...but load data infile will load a text / csv file.

[Don]

schueymcfee said:

So how can I get a CSV file to update a MySQL database?

Hire a pro and have him code you a little solution. Or do it yourself if you have the skills. If you're asking the question you should probably hire a pro.