Aggregate MySQL functions in html table via php - having problems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I want to build a table that is populated from a MySQL query and have
the table include some aggregate data (mean, sd, and cv).
 
If I select 'avg(RawData) as Mn' - and then stuff Mn into the table -
life is good.
If I try and select just RawData and computed the mean and sd at the
time the table is created, I get an error 'Unidentified index:
avg(RawData) in <php file name> at line <where I try and do the avg and
sd>
 
The format used below that does not work came from a suggestion by Oli
(the original suggestion used echo rather than printf, but it seems to
me the concept should be identical - am I wrong here???).
 
I have a working method so I am in good shape, I'm just trying to learn
other ways to get the same result.  Any tips or pointers are
appreciated.
 
Doug
 
/////////////// Query for STATISTICAL data
/////////////////////////////////
$sql = "SELECT
RunID, ItemSN, RawDataDesc, ReasonRun, RawData,  //note, I've tried with
including and excluding RawData from this query - no change in the error
Avg(RawData) as Mn, Std(RawData) as SD,                 //note, I've
tried leaving this line in and taking it out - no change in the error.
(Std(RawData)/Avg(RawData) * 100) as CV
FROM $table
Where RawData != 'Passed' and RawData != 'Failed'
Group By RawDataDesc";
 
echo "<br><br>";
 
$result = mysql_query($sql, $link)
or die(mysql_error());
 
echo "This is the statistical data report for Item: $table <br><br>";
echo "<table border=1>\n";
echo "<tr><td>RunID</td><td>ItemSN</td><td>RunReason</td><td>Desc</td>
<td BGCOLOR='33FF99'>Mean</td><td BGCOLOR='99FFCC'>SD</td><td
BGCOLOR='FFCC66'>CV</tr>\n";
 
while($myrow = mysql_fetch_assoc($result)) {
printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td>
<td BGCOLOR='33FF99'>%.1f</td><td BGCOLOR='99FFCC'>%.2f</td><td
BGCOLOR='FFCC66'>%.2f</tr>\n",
$myrow['RunID'], $myrow['ItemSN'], $myrow['ReasonRun'],
$myrow['RawDataDesc'],
$myrow['Mn'], $myrow['SD'], $myrow['CV']);
// this works fine every time
//$myrow['avg(RawData)'], $myrow['std(RawData)'], $myrow['CV']);     //
this was suggested by someone on this list but returns Unidentified
index: avg(RawData)
in <php file name> at line <this line when uncommented and used
}
 
echo "</table>\n";

_______________________________________________________________________
This e-mail message has been sent by Kollsman, Inc. and is for the use
of the intended recipients only. The message may contain privileged
or confidential information. If you are not the intended recipient
you are hereby notified that any use, distribution or copying of
this communication is strictly prohibited, and you are requested to
delete the e-mail and any attachments and notify the sender immediately.

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux