I have a query stored in a PHP session like this:
$_SESSION[“qry1”] = ’ AND LOWER(`master`.` Centre_Code`) LIKE LOWER('%h67%')’
The querys are stored in a table as favourite searches. When the user selects one the query detail is moved to the PHP session
I would like to be able to update my ‘master’ table by passing the session value query. Is there an easy way to achieve this.
Thanks in advance,
As far as i understand your question, you can append this session variable next to select_command. For e.g.
$g->select_command = "SELECT i.id, invdate , c.name,
i.note, i.total, i.closed FROM invheader i
INNER JOIN clients c ON c.client_id = i.client_id WHERE 1=1".$_SESSION[“qry1”];
(where list1 is grid id)
You can also reload whole page as per requirement.
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!