Printable View
i am working on a website for car's inventory and customer requirement is to store 30 images for on car, i created sperated table for images and then 30 fields sperately to store the path of every image, is it best way to do this or is there else? how can i reduce the no fields to store all 30 image's paths
Regards,
Faxi
Well, first you can write a back-end cms that has file input fields to let you select the images from your computer to upload. Next, store all the images in the same folder on your server...this way, in your database you only have to store the filename and not the full path+filename.
Finally, you could store the product_id, car_title, car_details in a mysql table called cars with a key field called cars_id. Next, you can create a table called car_photos like so...
id | car_photo | cars_idx
cars_id would be equal to cars_idx
This would take care of the issue if less than 30 photos or more than 30 photos where associated with a particular car. example :
TABLE "cars"
cars_id | cars_name | cars_desc
1 1990 Jaguar Nice Jaguar
9 2006 Datsun Sardine Can
TABLE "car_photos"
id | car_photo | cars_idx
1 jaguar_01.jpg 1
2 jaguar_02.jpg 1
3 jaguar_03.jpg 1
...
31 datsun_01.jpg 9
32 datsun_02.jpg 9
...
then a query like so :
select car_photo from cars,car_photos where cars_id=cars_idx
hope this gives you some alternative ideas