Function for displaying data from seperate tables in same database.
I am trying to display two separate data fields from two separate tables but have them connected two each other in a repeat region. So basically I want the name of a user from table one, next to it I want the date of his last upload from table two.
So it would look like (USER 1 last uploaded on DATE)
right now I have something that looks like this for mySQL
SELECT uploads.`date`, subscribe.`date`, subscribe.subscribe2
FROM subscribe, uploads
WHERE subscriber = %s AND uploads.`date`= subscribe.`date` ORDER BY uploads.`date` DESC"
Am I on the right track or way off here? Why wont it work?