How do i do it? The best information i have gathered on a search of the net is that it is difficult. Can anyone explain the steps to me, or point me in the right direction?
You can't use SQL as a feed. Feeds are data formats, SQL is a language. Your choices are CSV, XML, SOAP, JSON, maybe a few others, depending on what you're doing and what your audience is. If it's all your code, server and client, use any format you like. If the intended audience is the public you have to use some standard. You can create the feed using SQL, but the feed can't be SQL. First step - learn enough programming that you can write the code to do what you need, or post the details and, if it's not too complex, someone might write it for you.
Mr Rukbat. Thanks for your reply. Judging by your answer its obvious my question was too vague, and poorly written. I have a csv file containing all of the information for the products I want in the feed. I have an SQL database available on the web server. How do i get the information from the CSV file in to the database? I know a small amount of SQL, and I am sure I can pick up the rest that I need on the net somewhere, but I don't know where this code would be located, or how to refer to it from the HTML page that will contain the feed. Is this a more reasonable set of questions or am I still missing the point somewhere?
Use Navicat. Can upload to a bunch of database types from a bunch of file formats. If you're looking for something automated or real-time, you would need to create a custom program or script.
Ok thanks, looks like i need a bit more help than I thought, will have to start with the basics I guess.