|
I'm hoping someone can help me out with this. I'm somewhat new to PHP and I'm just not sure how to go about this.
The first thing I need to do is connect to a MS SQL database using a system DSN called "pricingdb". I'm not sure the proper string for an MS database.
Next, I need to perform a SQL query that is a little advanced for my knowledge. I need to pull the product price (LISTPRICE) from my table (PRODUCTS). Where this gets tricky is that I need to pull the price for more than one product, but the products are not sequential. So I need to pull the price for "R100", "R105", "R105E", and "R122".
Now, when I display the product price, they will NOT be displayed in any kind of row. Each product will be displayed separately, with accompanying product description text (which is not in the DB). So I'm figuring the easiest way to go about this is to put the prices in variables so I can just display the price variable where needed.
Can anyone help me with this?
|
