\n"; require "dbConnect.php"; require "../../plugins/php/ricoResponse.php"; $id=isset($_GET["id"]) ? $_GET["id"] : ""; $parent=isset($_GET["Parent"]) ? $_GET["Parent"] : ""; echo "\n"; if ($id == "") { echo "\n"; echo "\nNo ID provided!"; echo "\n"; } elseif (!OpenDB()) { echo "\n"; echo "\n".htmlspecialchars($oDB->LastErrorMsg); echo "\n"; } else { $oDB->DisplayErrors=false; $oDB->ErrMsgFmt="MULTILINE"; $oXmlResp=new ricoXmlResponse(); $oXmlResp->convertCharSet=true; // MySQL sample database is encoded with ISO-8859-1 echo "\n"; if ($parent) { $oXmlResp->Query2xmlRaw("SELECT '$parent',CustomerID,CompanyName,'L',1 FROM customers where CompanyName like '$parent%'",0,99); } else { $oXmlResp->WriteTreeRow("","root","Customer names starting with...","C",0); $oXmlResp->Query2xmlRaw("SELECT distinct 'root',left(CompanyName,1),left(CompanyName,1),'C',0 FROM customers",0,99); } print "\n".""; if (!empty($oDB->LastErrorMsg)) { echo "\n"; echo "\n".htmlspecialchars($oDB->LastErrorMsg); echo "\n"; } $oXmlResp=NULL; } echo "\n"; ?>