DataTables server-side SQL query
DataTables server-side SQL query
kagatan
Posts: 3Questions: 2Answers: 0
Please tell me whether it is possible to construct a database query to the following:
"SELECT t_users.phone, t_users.uid, t_users.user, t_users.fio, t_users.deposit, t_packets.packet FROM 't_packets' , 't_users' WHERE t_packets.gid = t_users.gid"
Request do with the following files:
server_processing,php and ssp.class.php
Slightly modifying files, half earned request :)
"SELECT t_users.phone, t_users.uid, t_users.user, t_users.fio, t_users.deposit, t_packets.packet FROM 't_packets' , 't_users' "
What should be done to understand the "class SSP" more and
WHERE t_packets.gid = t_users.gid
?
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Take a look at this thread: http://datatables.net/forums/discussion/19356/1-10-and-server-side-table-joins .
However, the SSP class wasn't specifically designed for joins - you will need to either modify it or create your own script.
Allan