How do I assign the foreign key to the field 'dates' in the table 'subscriber', the code I have now looks like...
SELECT uploads.*, subscribe.*
FROM uploads
INNER JOIN subscribe on uploads.message_id = subscribe.date
WHERE subscriber =%s AND uploads.`date`= subscribe.`date`
ORDER BY uploads.`date` DESC
and is still not getting any results.