How to get data from foreign key to datatables?
How to get data from foreign key to datatables?
Watchara
Posts: 30Questions: 5Answers: 1
My foreign key is integer and when I pass data to datatables
Example.
IPAddress | SerialNumber | User |
192.168.1.1|8C11222 | 1 |
I need to get username by UserID
How to solve this problem? Can anyone suggest me?
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
You need to do a JOIN in your SQL statement to get the user information as well.
Allan
Thank you. Mr.Allan
Watchara