PHP connector unable to fetch a simple db query.

Suite and Optimus Suite 5
#1

Hi,



I am trying to use the PHP connector to fetch a simple query from DB and it doesnt work!!!



Here is what i am trying to do:

==================



<?php

$category = $_GET[‘category’];

require_once("…/dhtmlx/connectors/grid_connector.php");

$res = mysql_connect(“localhost”,“root”,“123456”);

mysql_select_db(“mt”);

$grid = new GridConnector($res);

$grid->render_sql(“select a.* from meetings a where a.category = ‘$category’ and a.meetID in(select b.meetID from attendees b)”,“a.meetID”,“meetID,subject,chair,date,stime”,"","");

?>



I get an xml error when i do the above, however when i remove the subquery(given below) then it works,



$grid->render_sql(“select a.* from meetings a where a.category = ‘$category’ “,“a.meetID”,“meetID,subject,chair,date,stime”,””,"");





Is there no support of subqueries ? Please help.











#2

subqueries isn’t supported at the dhtmlxConnectors ver 0.9. You can download new version here dhtmlx.com/docs/products/dhtmlxC … ndex.shtml