Hi,
should be easy...but battling.
I want to print the data from two mysql tables in a html table. I want to print everything from table_1 (username and nickname). And if I have their email address in table_2, I want to print that in the same row in the html table. The two tables have the common field userID. But table_2 does not have email addresses for all users. This is where I'm having problems.
I am able to either print the info for users who's email address are in table_2, or I end up printing duplicates of users in table_1.
How can I neatly print the user info and their email address when it is present?
extract from 2 tables but have missing data
Moderator: General Moderators