Hey all...new here.
I"ve struggled with this for hours now. I always try and find the answers before I post, so I hope someone can help me.
I'm trying to pull four fields from two different tables in my database. I"m working on a feature that allows people to post in other members areas.
the outline would be:
Posted by "username"...."date created"....."comment"
I have two tables that hold this information. I think that I have to use the user id from table one that holds the actual users ID and make it equal to the other table that holds the userID that posted the comment. That way the two ID's will match in the output.
So I have two tables... one for members....and one for posts...
members table holds:
Now how in the world would I call all of this out of the database in one query? LOL. If I can do that, then I should be able to just <?php echo everything where I want it.
posts table holds:
Thanks for any help and direction.