I am coding an ecom site in dreamweaver, php, mysql, on my local testing server. I am using dreamweaver built-in php code for this.
I have designed the database, and have reached the stage of displaying records on the browser. I need some things done before I go further:
Images are stored in a file folder, and not uploaded to mysql db.
  1. How do I store image information on the database? What fields do I need, and what information should be entered in each field?
  2. How do I retrieve images from the database to display with the corresponding recordset? For e.g. show an image for each category on category display page.

Can someone help me with this? Appreciate it.

ps: please no comments about using dreamweaver code, as this is for practice for a test I am about to give.