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.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?