[thelist] sorting averages by using PHP

Murat Tutumlu tutumlum at yahoo.com
Fri Mar 25 01:43:45 CST 2005


Hi everybody,

I have a table which named as Studentmarks1 with
"Student_no, lesson, class, V1, V2, F1, V3, V4, F2"
columns.
"V1, V2, F1, V3, V4, F2" are numbers over 100. I
printed averages of classes and it is sorting by class
name as shown in code below.
My problem is sorting by averages. I tried, but I
couldn't.. 
Any suggestion?
Thanks in advance..

Here is my code.
<?
include "config.php";
$result = mysql_query("SELECT * FROM Studentmarks1
group by Class ",$db);
$myrow = mysql_fetch_array($result);
?>
<form action="" method="post" name="form1"
target="_self">
  <select name="exam">
    <option value="">Choose an exam</option>
    <option value="V1">Visa 1</option>
    <option value="V2">Visa 2</option>
    <option value="F1">Final 1</option>
    <option value="V3">Visa 3</option>
    <option value="V4">Visa 4</option>
    <option value="F2">Final 2</option>
  </select>
<input type="submit" name="Submit" value="Show">
</form>
<?

do { 
 
$sql = mysql_query("SELECT AVG($exam) FROM
studentmarks1 WHERE class='$myrow[Class]'",$db); 
$aver = mysql_fetch_array($sql); 
$aver[0] = number_format ($aver[0], 2);

echo "$myrow[Class] : $aver[0]<br>";

 } 
while ($myrow = mysql_fetch_array($result));

?>


		
__________________________________ 
Do you Yahoo!? 
Make Yahoo! your home page 
http://www.yahoo.com/r/hs


More information about the thelist mailing list