Forum Moderators: open
I have a simple MySQL query that does a count to return values for 4 groups. I would like to store those values in a php array for later use but am a bit unsure of the syntax. I can get the values and write them out on the fly but am having difficulty storing them (and subsequently writing them ) after the connection is closed. here is my code snippet:
$Query = "SELECT qResultClass, COUNT(qTimeStamp) FROM quiz GROUP BY qResultClass";
$Result = mySql_db_query ($DBname, $Query, $Link);
while ($Row = mySql_fetch_array ($Result)) {
echo "There are ". $Row['COUNT(qTimeStamp)'] ." ". $Row['qResultClass'] ." items.";
echo "<br />";
}
mySql_close ($Link);
$values = array();
while ($Row = mySql_fetch_array ($Result)) {$values[ $Row['COUNT(qTimeStamp)'] ] = $Row['qResultClass'];
}foreach ( $values as $k => $v ) {
print ``$k is the key for $v<br />\n'';
}print_r($values);
I am getting closer! I plugged in your solution and for some reason I am missing the first result set. I kept my first echo statement in to compare values as follows:
$Query = "SELECT qResultClass, COUNT(qTimeStamp) FROM quiz GROUP BY qResultClass";
$Result = mySql_db_query ($DBname, $Query, $Link);
$values = array();
while ($Row = mySql_fetch_array ($Result)) {
echo "There are ". $Row['COUNT(qTimeStamp)'] ." ". $Row['qResultClass'] ." items.";
echo "<br />";
$values[ $Row['COUNT(qTimeStamp)'] ] = $Row['qResultClass'];
}
foreach ( $values as $k => $v ) {
print $k . "is the key for " . $v . "<br />\n";
}
mySql_close ($Link);
print_r($values);
****************************
and my result is:
****************************
There are 3 1 items.
There are 3 2 items.
There are 1 3 items.
There are 2 4 items.
3is the key for 2
1is the key for 3
2is the key for 4
Array ( [3] => 2 [1] => 3 [2] => 4 )
Any ideas? Thanks again for your help!
Eric B
$Query = "SELECT qResultClass, COUNT(qTimeStamp) FROM quiz GROUP BY qResultClass";
$Result = mySql_db_query ($DBname, $Query, $Link);
$values = array();
while ($Row = mySql_fetch_array ($Result)) {
echo "There are ". $Row['COUNT(qTimeStamp)'] ." ". $Row['qResultClass'] ." items.";
echo "<br />";
$values[ $Row['qResultClass'] ] = $Row['COUNT(qTimeStamp)'];
}
foreach ( $values as $k => $v ) {
print $k . "is the key for " . $v . "<br />\n";
}
mySql_close ($Link);
print_r($values);
