how do I narrow results?

[rprincejr]

I cant figure out how to narrow the results of the query below. It outputs the MAX(r.results_bigfish) for every team on each schedule. Im trying to narrow it down to the biggest fish per schedule which would be 1 per schedule. Man, Im stumped.

$query2 = mysql_query("SELECT r.sched_id, r.team_id,
                MAX(r.results_bigfish) AS bfish,
                s.date_m, s.date_d, s.date_y
                FROM ".$prefix."_classic_results r
                INNER JOIN ".$prefix."_classic_schedules s ON r.sched_id = s.sched_id
                GROUP BY r.sched_id, r.team_id
                ORDER BY s.date_y DESC");


while($row2 = $db->sql_fetchrow($query2)) {
                $result = mysql_query("SELECT team_id,
                partner1_firstname, partner1_lastname,
                partner2_firstname, partner2_lastname
                FROM ".$prefix."_classic_teams WHERE team_id = $row2[team_id]");
                list($team_id, $partner1_firstname, $partner1_lastname, $partner2_firstname, $partner2_lastname) = $db->sql_fetchrow($result);
                echo "<td width=\"50%\"><strong>$row2[date_m]-$row2[date_d]-$row2[date_y]<br>$partner1_firstname&nbsp;$partner1_lastname&nbsp;/&nbsp;$partner2_firstname&nbsp;$partner2_lastname</strong><br>$row2[bfish]lbs.</td>";
              }

[sneakyimp]

i have no idea what 'the biggest fish' might mean mathematically (which is critical to finding you a solution) but let me suggest putting something in the ORDER BY part of your query which puts the biggest fish as the first result.

something like ORDER BY fish_bigness DESC

and then add LIMIT 1

this will limit your query to the 1 record that has the largest fish_bigness value.