Error Load From PHP

Suite and Optimus Suite 5
#1

Hi all i have some problems whit the conection from php i try to conect from odbc and i have a error that i cant resolved any one can help me please???

this is my error :


^

this my code:

    <?php
        
		//set content type and xml tag
		header("Content-type:text/xml");
     
        //define variables from incoming values
        if(isset($_GET["posStart"]))
            $posStart = $_GET['posStart'];
        else
            $posStart = 0;
        if(isset($_GET["count"]))
            $count = $_GET['count'];
        else
            $count = 100;
 
        //connect to database
		

		$server   = "KEVIN-PC\SQLEXPRESS";
		$database = "KN_ONLINE";
		$user     = "";
		$password = "";
		
        $link = odbc_connect("Driver={SQL Server};Server=$server;Database=$database;", $user, $password);

 
        //create query to products table
        $sql = "SELECT  * FROM user_knights_rank";
 
        //if this is the first query - get total number of records in the query result
        if($posStart==0){
         
			
		$sqlCount =  "Select count(*) as cnt from ($sql) as tbl "; 
		$resCount =  odbc_exec($link, $sqlCount);
		$rowCount = odbc_fetch_array($resCount);
		$totalCount = $rowCount["cnt"];
		
		
		
		
		
		
        }
 
        //add limits to query to get only rows necessary for the output
        $sql.= " LIMIT ".$posStart.",".$count;
 
        //query database to retrieve necessary block of data
        $res = odbc_exec($link, $sql);
 
       
        //output data in XML format   
        print("<rows total_count='".$totalCount."' pos='".$posStart."'>");   
        while($row=odbc_fetch_array($res)){
            print("<row id='".$row['id']."'>");
                print("<cell>");
                    print("item1");  //value for product name
                print("</cell>");
                print("<cell>");
                    print("item2");  //value for internal code
                print("</cell>");
                print("<cell>");
                    print("item3");    //value for price
                print("</cell>");
             print("</row>");
        }
        print("</rows>");
    ?>

Thanks …

#2

i agree that i use DHTMLX GRID

Thanks

#3

Should try to load that file in your browser. It show the XML and errors that you have in the actual XML.

I would need to see your web script and the names of your files to help further.

My system is set up with Table.PHP being the one with the DHTMLX Grid and runtime.php being the database connection string. I can load runtime.php and identify issues with the XML and access the XML with the Table.PHP to generate the grid.