|
|
|
Forum Newbie
Group: Forum Members
Last Login: 4/7/2008 12:37:32 PM
Posts: 4,
Visits: 8
|
|
Hi,
I just cannot seem to figure this out, the converting to XML is giving me real problems. Does anyone have a short example of pulling data from a recordset using ODBC connection from a access backend......
I have lots of web pages on our intranet that use PHP to display table, runs queries etc..... I would like to take some of these table and create a chart based on them...
I would appreciate any help...
Ardan
The Cake is a Lie!
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 4/7/2008 12:37:32 PM
Posts: 4,
Visits: 8
|
|
I finally got it, if anybody needs an obdc simple example
$conn=odbc_connect('yourODBCconnection','','');
$firststring= your SQL query string
$rs=odbc_exec($conn,$firststring);
$strXML = "";
while (odbc_fetch_row($rs))
{
$g1=odbc_result($rs,"field1");
$g2=odbc_result($rs,"field2");
$strXML .= "";
}
$strXML .= "";
//Create the chart - Column 3D Chart with data from strXML variable using dataXML method
echo renderChartHTML("./Charts/FCF_Column3D.swf", "", $strXML, "myNext", 800, 600, false);
?>
The Cake is a Lie!
|
|
|
|