Jump to content

Relational Database Problem


mssakib

Recommended Posts

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 :)

 

 

Link to comment
https://forums.phpfreaks.com/topic/244420-relational-database-problem/
Share on other sites

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.