I have created two database tables, One which holds all of the users information, and another which holds the name of the videos they uploaded and who uploaded it. How do I get information from both tables?
garyjohnson
14
Junior Poster
Recommended Answers
Jump to PostUse a join, something like this:
SELECT * FROM users, videos WHERE videos.user_id = users.id
All 4 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
garyjohnson
14
Junior Poster
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
garyjohnson
14
Junior Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.