intinya di relasi antara tabel USERS dan FILES..
tar select * from USERS, FILES where users.id = files.user_Id
Kalau misalnya begini kira-kira kode pemanggilannya gimana ya tuan..
KETERANGAN:
- Tabel USERS = id, username, password, email
- Tabel FILES = userID, fileName, fileExt, fileSize, fileDesc, created_at, fileDownloadCounter, filePath
PERINTAH:
- Upload By = username
- File Name = fileName
- File Type = fileExt
- File Size = fileSize
- Description = fileDesc
- Create Date = create_at
- Total Download = fileDownloadCounter
- Action = filePath ( tombol "DOWNLOAD" )
Dibagian tabel USERS terdapat field "id" dan di tabel FILES terdapat field "UserID" dengan angka yg sama, apakah bisa di jadiin patokan tuan? kalau misalnya bisa, kira-kira kode nya bagaimana ya?