PHP/MySQL join 2 tables

7dodcom

New Member
I've got one mysql table with usernames, passwords and property names, that allows a user to log-in to a secure site section. Now what I'd like to be able to do is pull-in pdfs from a second table where it checks the property name from table one against the documentCategory of the pdfs in table two, and then only displays the relevant pdfs depending on the logged-in user. (Hope this makes sense)Table structure:\[code\]Table 1 - userid password propertyTable 2 - pdfFile documentCategoryWhere table1.property = table2.documentCategory\[/code\]Any help on how I can get this working in php would be greatly appreciated as I'm now completely lost.
S
 
Back
Top