I want to query a sql command instead of giving the table name in ssp::simple.
I want to query a sql command instead of giving the table name in ssp::simple.
sahu_golu
Posts: 3Questions: 2Answers: 0
Basically, I need to print two tables in one single table.
This discussion has been closed.
Answers
I'm not getting the connection between your title and your text. Please give a more detailed explanation.
In ssp::simple , we pass a table name but I want to pass a myql query to union two tables.
Not sure whether this is going to work. Maybe better to define a view and then work with this?! Please also see this:
https://datatables.net//forums/discussion/comment/111357/#Comment_111357
Yup - the SSP class is a demo only really. It isn't designed to be an entire SQL / PHP abstraction. If you want a UNION you either need to go with a VIEW or modify the SSP class to work with the SQL you need.
Allan