The following one goes well, but when i changed to read $sql statements from included file,
Fatal error: [] operator not supported for strings in /home/apache156/htdocs/cgitools/bargraph.php appears..
Source that works well:
Code: Select all
$con = mysql_connect($ServerName,$UserName,$PassWd);
mysql_select_db($DBName,$con);
$sql = "SELECT month(date_st) AS `mth` , SUM(cnt) AS `sum_cnt`
FROM data_tbl
WHERE year(date_st)=2004
GROUP BY month(date_st)";
print "<br>sql=$sql<br>";
$list = mysql_query($sql, $con);
while($row = mysql_fetch_array($list)){
$data[]=$row[sum_cnt];
$leg[]=$row[mth];
}Code: Select all
$con = mysql_connect($ServerName,$UserName,$PassWd);
mysql_select_db($DBName,$con);
include("if.php");
print "<br>sql=$sql<br>"; //$sql contains the correct statement
$list = mysql_query($sql, $con);
while($row = mysql_fetch_array($list)){
$data[]=$row[sum_cnt];
$leg[]=$row[mth];
}Code: Select all
<?php
if($data=="wages" && $period=="annual"){ //$data & $period was defined in the above script
$sql = "
SELECT month(date_st) AS `mth`, SUM(cnt) AS `sum_cnt`
FROM data_tbl
WHERE ope=1 AND
account!=03 AND
year(date_st)=$a_year
GROUP BY month(date_st)";
}
?>