mssakib Posted August 10, 2011 Share Posted August 10, 2011 Hi I have 2 table in a database. First one holds info about uploaded files(ID,Filename , Filepath and date) and second one hold information about the users (username ,pas etc). Now i want that when a user logs in and uploads files in uploader files table his name will be there. like user MAC uploader these file... . I hope you understand it Quote Link to comment https://forums.phpfreaks.com/topic/244420-relational-database-problem/ Share on other sites More sharing options...
AbraCadaver Posted August 10, 2011 Share Posted August 10, 2011 Well, you will have to insert the user id in the table with the uploaded file information, then it is fairly easy: SELECT * from files, users WHERE files.user_id = users.id Or something similar depending on what you are selecting. Quote Link to comment https://forums.phpfreaks.com/topic/244420-relational-database-problem/#findComment-1255389 Share on other sites More sharing options...
mssakib Posted August 10, 2011 Author Share Posted August 10, 2011 nah i just solved it .. :P though thx bro Quote Link to comment https://forums.phpfreaks.com/topic/244420-relational-database-problem/#findComment-1255396 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.