Selecting a sql subset when using the generator
Selecting a sql subset when using the generator
I'm using the generator to create modules for use with the editor library.
It works very well when selection the whole dataset using the generator tool
However I need to be able to programmatically create a subset of data rather than the complete data table
So select * from table where firstname ='xxxxx'
rather than just select * from table
I''d like to have the where dynamic and accessible from server side hopefully using a PHP variable
Any tips appreciated - thanks for taking a look
This question has an accepted answers - jump to answer
Answers
Details on how to apply a condition to the generated PHP are available here.
Allan
Brilliant - thanks very much