jQuery Grid Plugin - jqGrid - Topic: where clause and get parameter (php/mysql)? http://www.trirand.com/blog/?page_id=393/help/where-clause-and-get-parameter-phpmysql Simple:Press Version 5.7.5.3 davgino on where clause and get parameter (php/mysql)? http://www.trirand.com/blog/?page_id=393/help/where-clause-and-get-parameter-phpmysql#p20728 Help http://www.trirand.com/blog/?page_id=393/help/where-clause-and-get-parameter-phpmysql#p20728 see in demo verion 3.6 ->Ajax Improvements. where you want add any variable

]]> Wed, 10 Nov 2010 16:18:30 +0200 amilovac on where clause and get parameter (php/mysql)? http://www.trirand.com/blog/?page_id=393/help/where-clause-and-get-parameter-phpmysql#p20727 Help http://www.trirand.com/blog/?page_id=393/help/where-clause-and-get-parameter-phpmysql#p20727 Hi everyone,

I need to pass a parameter to the php file which selects the data and puts them into xml file needed bu a grid. Is there a way to add an extra  GET parameter to the url and use it in a where clause:

$("#list").jqGrid({
    url:'js/JQgrid/grid.php?q=1&some_get_variable=1000',
    datatype: 'xml',
    mtype: 'GET',

...select * from some_table where client_id="some_get_variable"

Thanks,

Aleksandar

]]> Wed, 10 Nov 2010 14:34:19 +0200