[dholl328]

Starting a new web site. The site will contain about 100 items to be sold (flowers and plants). Is a mySql database needed or can php handle a db record as an array of about 8 columns times 100 rows? The record will need to have a picture field, short description, long description, cost. A unique identifier will be the key field on each record. Ideas?

Thanks for the kickoff.

Know of any sample code?


dh

[CrAzY_CuStoMs]

You can do it either way, but SQL is better, cuts down the loading time. More secure aswell. id say go with SQL for something like this.

[4n7hr4x]

yeah mySQL is the best, if you were to use php to record all that stuff to a text file it would be a huge mess and it would be very difficult to do

[dholl328]

Thanks. Haven't done sql in years. time to brush off the programming cob webs i guess.. still looking for code samples...

[4n7hr4x]

tell me if you need any help

[dholl328]

i created the db structure in mysql (first pass but should be close): id#, category, short name, short desc, long desc, thumbpicture (blob), largepicture (blob), pricelow, pricemed, pricehigh;

next i will populate with several test records;

then it is time to link to the web page with php/sql?

each picture will have 3 select buttons (low price, med price, high price); best way to handle?

also, when a user clicks on a picture to see the big picture with additional information (the long description), how is this trapped?

thxs!

[FiRe]

http://cubecart.com

[Merovingian]

OScommerce is the best.
www.oscommerce.com

[moronovich]

hi all,
you can also have a visit to this open source project:
http://sourceforge.net/projects/oscmall