Here's my two tables (images), I need help pulling data.

Here's my two tables:

http://www.zdot.com/ezu_files.jpg
http://www.zdot.com/ezu_uploadinfos.jpg

Tables are named ezu_files and ezu_uploadinfos.

What I'm trying to do is match up the uploaded images to the addresses and username.  Some addresses will have one or two pictures while others will have up to 16 images. 

I've tried various SQL statements, some come close, but none give me exactly what I'm looking for.  That's why I'm posting images of my two tables so somebody with more knowledge of MySQL can help me out.  Thank you.

Hi Shawn,

How do you want the data to be displayed on the Html page?
How would you like to display zero, one or several files for an acount?

I'll have a user login page where I'll simply display each address, price, and a single picture (haven't figured out the pic yet).

For visitors looking up property they will click on the city and it will show 10 listings per page.  When they click on the address it will take them to a detail page of the property where they can print out fliers.

Here's some more links so you can see what I'm talking about.

http://zdot.com/home_detail.jpg
http://zdot.com/user_login.jpg
http://zdot.com/city_results.jpg

The main page is HomesOnTheGulf.com, the Diamondhead link is the one I'm working with. I'll finish the others once I can grasp this. Smile.


Thanks Skrol.