Need a little help with organization

[Shawn Northrop]

Hey all,
Im trying to build a site and am getting a little stuck with the layout. If anyone has any advice i would appreciate it.

The site will have users create an account: (adds an entry into the table user)
user contains: firstname lastname email and a few other things.

Next the users will be able to post an add
I built another table (ads) and have each entry contain descripition, subject, price, firstname, lastname, email, id.

i want each description to belong to one of the users and have their first last and email attached to it.

Next i need the users to be able to upload multiple pictures for each ad. I was thinking about building another table called images:

imagename, imagedata, id(would be set to the corresponding id from the ads table).

Also I would want to allow users only a certain number of images.

I feel like this may work however i would imagine there is a much easier/more organized way to achieve this.

Anyone have any ideas?

[ScarletPimpernal]

Hi Shawn Northrop ,

User Table --> User details.
User Posts --> Post details with reference of UserTable(pk).
User Pictures --> Pictures details with the Reference of the Posts(pk).

This what u need ?