Code: Select all
<?php
//get all the golfers rounded up in no particular order
$result2 = mysql_query("SELECT * FROM golfers ORDER by Lgname $srtby") or die("Query failed : " . mysql_error());
$num2=mysql_numrows($result2);
$i=0;
while ($i < $num2) {
$holesplayed2=mysql_result($result2,$i,"holesplayed");
$golfercomp2=mysql_result($result2,$i,"golfercomp");
$golferL2=mysql_result($result2,$i,"Lgname");
$golferF2=mysql_result($result2,$i,"Fgname");
$golferID=mysql_result($result2,$i,"IDg");
//get all the results for each golfer
$result = mysql_query("SELECT * FROM golfers, contacts, monies WHERE golfers.IDg = monies.MgolferID AND contacts.ID = monies.McontactID AND MgolferID='$golferID'") or die("Query failed : " . mysql_error());
$num=mysql_numrows($result);
$l=0;
while ($l < $num) {
$holesplayed=mysql_result($result,$l,"holesplayed");
$golferL=mysql_result($result,$l,"Lgname");
$golferF=mysql_result($result,$l,"Fgname");
$mID=mysql_result($result,$l,"IDm");
$jrsr=mysql_result($result,$l,"jrsr");
$mrmrs=mysql_result($result,$l,"mrmrs");
$Fname=mysql_result($result,$l,"Fname");
$Lname=mysql_result($result,$l,"Lname");
$paid=mysql_result($result,$l,"Mpaid");
$onetime=mysql_result($result,$l,"Monetime");
$pledge=mysql_result($result,$l,"Mpledge");
$golferID2=mysql_result($result,$l,"MgolferID");
$conID=mysql_result($result,$l,"ID");
$totalpledge = mysql_result($result,$l,"Mtotalpledge");
$total += $totalpledge;
$l++;
}
//here is where we would like to sort our data, I think..
//put a zero in for no data
if($total == ""){
$total = '0';
}
$gname = "$golferF2 $golferL2";
$array = array($total, $gname);
unset($total);
//displays the results nice, but not how I want it
/*echo "$golferF2 $golferL2";
setlocale(LC_MONETARY, 'en_US');
echo money_format('%(#10n', $total) . "<br><br>";
unset($total);*/
$i++;
arsort($array);
while (list($key, $val) = each($array)) {
echo "$val <br><br>";
}
}
?>$srtby is a variable that got copied from another page, sorry about the confusion. That sort doesn't actually need to happen. I know there are a few things I can trim!
I have 3 tables to get results from, here is how I get what I want:
1. the page goes and gets golfer info from 'golfers' (Loop 1)
2. WHILE in the loop it grabs all the info from 'contacts' and 'monies' WHERE it sees a pledge from a golfer AND adds all the data from a column and saves it as a variable:
$totalpledge = mysql_result($result,$l,"Mtotalpledge");
$total += $totalpledge;
3. OK, so now we have the total pledged money amount for my golfer, and after the loops complete, a list of golfers with the total money pledged to each golfer next to them. I want to sort the list from highest to lowest based on the variable $total, before the page is displayed.
-Pete
feyd | please use
Code: Select all
tags whileCode: Select all
is offline[/color]