Is there a php/mysql script that will easily display data from a DB?

[budbiss]

I have about 300 product names, descriptions and prices. I want to enter them all into a database and then make it so that visitors can easily access and filter through the data depending on price (assending or descending) description, etc. Does anyone know of a script that already does this?

[brotherhood of LAN]

Get yourself a copy of phpmyadmin or another interface, you can use that to understand what sort of queries you will need to use.

You might also have better luck in one of the server side forums with the q ;)

[StupidScript]

budbiss, you should post this in the PHP forum. There is all sorts of PHP code around which will do what you need. The tricks are (a) building your particular database and then (b) using one of the manymany simple techniques using PHP to collect and display the data.

It's simple in concept, but its complexity will vary depending on the demands placed by your data and the level of filtering you want to implement.

[budbiss]

Thank you Stupidscript for the input. BTW, sorry I posted in the wrong forum...I was at work at the time and being in a hurry must have overlooked the PHP forum.

Anyways, the only fields I will need to have in the database are Price, Manufacturer, Product Line, Short Description, Detailed Description, On Sale, Sale Price, Sale Description. As far as filtering, it will just be keyword search or list by product line.

Please let me know if you guys have any ideas. I'll be sure to let you all know if I come across anything myself. Thanks!

[budbiss]

So does anyone know where I can get any info on coding this myself?

Also, I have all the data in excel format...any ideas on how I could easily export this to a mysql db?

[willybfriendly]

Google PHP tutorials

You can import a CSV file into MySQL

WBF

[budbiss]

Are there any tutorials out there for doing this spefic task? If there are, I'm not finding them.

[willybfriendly]

fgetcsv - [us2.php.net...]
LOAD DATA INFILE - [dev.mysql.com...]

WBF