[mcouvillon]

I run a price comparison web located at Online Pharmacy Prescription and i want to have my site run off of a database (mysql) on a server. The site lists the pharmacy, drug and dosage, quantity, lowest price and 2 affiliate links. One to the pharmacy home and one to the individual product. How would one accpomplish this. does anyone know of any scripts which would let me use a current database and customize the display? example... use a field as a link? I also need to be able to sort by lowest price and only display one drug per page but seperate the different dosages into different parts of the page. Please help.

[the|Skrilla]

arange your database with the following fields:

id - pharmacy - drug - dosage - quantity - lowest price - affiliate link 1 - affiliate link 2

then create a few rows of data and create a script which interprets the data. This is probably going to be a total of 50 lines of php, not including the html output.

As for the sorting, that is all a matter of how you word the query (SORT BY price ASC or SORT BY id DESC, etc.)