I have struggled with this for a while and seem to have a problem I cannot solve. I tried using the documentation for setting up mySQL with the gridbox. I also tried the dhtmlxcommon_debug javascript which did not seem to help much. My code that I tried is below with some original sections commented out. Thanks,
******************<—PHONE.HTML CODE BELOW, means of entry–>
Radiologist phone list
<-get.php below*>
<?php
//include db connection settings
//change this setting according to your environment
require_once(‘config.php’);
require_once(‘config_dp.php’);
require(“grid_connector.php”);
$res=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
mysql_select_db($mysql_db);
//include XML Header (as response will be in xml format)
//header(“Content-type: text/xml”);
//encoding may be different in your case
//echo(’<?xml version="1.0" encoding="iso-8859-1"?>’);
//output data from DB as XML
//$sql = “SELECT * from samples_grid”;
//$res = mysql_query ($sql);
//mysql_select_db($mysql_db);
$gridConn = new GridConnector($res,“MySQL”);
$gridConn->render_table(“attendings”,“phone”,“residents”,“phone2”,“reading rooms”,“phone3”,“pager numbers”,“phone4”);
/if($res){
while($row=mysql_fetch_array($res)){
//create xml tag for grid’s row
echo ("<row id=’".$row[‘book_id’]."’>");
print("");
print("");
print("");
print("");
print("");
print("");
print("");
print("");
print("");
print("");
}
}else{
//error occurs
echo mysql_errno().": “.mysql_error().” at “.LINE.” line in “.FILE.” file
";
}
echo ‘’;
/
?>