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?
Okay so I have altered the code you gave me and I want it to join the other database with the email of the current user logged on,
$email = $_SESSION['email_of_user'};
SELECT * FROM db_name, table_name WHERE table_name.email = $email
I want it to display a different field in the row that has the same email as the user. So I uploaded a video and named it Funny, that video name was saved into a database table that aslo saved my email. I want the code to display the video name, not the email once it is joined.
This is the code that inserts my information into the dataabase, called radhalfs, and it stores this information into a table named videos. It saves the videoname created by the user, user email and the real video file name.