Need help to save a lot of time

eaglesfan17

Okay I'm writing a script that goes like this:

echo "<table><tr><td><table cellspacing=0 class=border cellpadding=5><tr><th colspan=3>Offensive Matchup</th></tr>";

            for($count=0;$count<$num_res;$count++){
        $team1 = strtolower(mysql_result($res,"team") );
        $wins = mysql_result($res,$count,"wins");
        $loses = mysql_result($res,$count,"loses");
        $ties = mysql_result($res,$count,"ties");



    echo "<tr>";
    echo "<th colspan=2 align=right><img src=/images/nfl_logos_large/" . strtolower($team1) . ".gif></th>";
    }



    $query = "select team, wins, loses, ties, pts_for, pts_agst from standings where league_id=$league_id and season=$season and team=\"$team2\" order by wins/(wins+loses) DESC LIMIT 1";
    $res = mysql_query($query,$db);
    $num_res = mysql_num_rows($res);


                for($count=0;$count<$num_res;$count++){
        $team2 = strtolower(mysql_result($res,"team") );


    echo "<th><img src=/images/nfl_logos_large/" . strtolower($team2) . ".gif></th>";
    echo "</tr>";

    }
    $query = "select team, wins, loses, ties, pts_for, pts_agst from standings where league_id=$league_id and season=$season and team=\"$team1\" order by wins/(wins+loses) DESC LIMIT 1";
    $res = mysql_query($query,$db);
    $num_res = mysql_num_rows($res);

                for($count=0;$count<$num_res;$count++){
        $team1 = strtolower(mysql_result($res,"team") );
        $wins = mysql_result($res,$count,"wins");
        $loses = mysql_result($res,$count,"loses");
        $ties = mysql_result($res,$count,"ties");

            if($week==1){
            $wins = 0;
            $loses = 0;
            $ties = 0;
        }


    echo "<tr>";
    echo "<td>Record</td>";
    echo "<td>(" . $wins ."-" . $loses . "-" . $ties[$old_count + $count] . ")</td>";

    }

        $query = "select team, wins, loses, ties, pts_for, pts_agst from standings where league_id=$league_id and season=$season and team=\"$team2\" order by wins/(wins+loses) DESC LIMIT 1";
    $res = mysql_query($query,$db);
    $num_res = mysql_num_rows($res);

                for($count=0;$count<$num_res;$count++){
        $team2 = strtolower(mysql_result($res,"team") );
        $wins = mysql_result($res,$count,"wins");
        $loses = mysql_result($res,$count,"loses");
        $ties = mysql_result($res,$count,"ties");

            if($week==1){
            $wins = 0;
            $loses = 0;
            $ties = 0;
        }


    echo "<td>(" . $wins ."-" . $loses . "-" . $ties[$old_count + $count] . ")</td>";
    echo "</tr>";
    }

    echo "</table>";
?>

Okay, basically what I'm asking is how do I save myself a lot of time by not repeating the query and "for" sections over and over again (I plan on adding several more rows to this script). I know it's a lot of code, but if someone could lend me a hand I would be greatly obliged.

The script in action : http://www.pmlfootball.net/matchup.php?team1=Eagles&team2=Bears

leatherback

WHAT is the result you are trying to achieve?

(Sorry, cannot really be bothered to go thrugh longs lists of code, which for sure can be written more efficiently).

Do you have an example of the sort of output you try to achieve? Or the sort of info you want to display?

eaglesfan17

http://www.pmlfootball.net/exp3.php

That is what I'm trying to achieve

But the problem is, Well if you look closely, the only reason I have 2 queries is because in one query team=\"$team1\" and in the 2nd query team=\"$team2\"....I'm being forced to repeat my query after every <td> like so:

echo "<tr>";
        echo "<td>Record</td>";
        echo "<td>(" . $wins ."-" . $loses . "-" . $ties[$old_count + $count] . ")</td>";

    }

        $query = "select team, wins, loses, ties, pts_for, pts_agst from standings where league_id=$league_id and season=$season and team=\"$team2\" order by wins/(wins+loses) DESC LIMIT 1";
    $res = mysql_query($query,$db);
    $num_res = mysql_num_rows($res);

                for($count=0;$count<$num_res;$count++){
        $team2 = strtolower(mysql_result($res,"team") );
        $wins = mysql_result($res,$count,"wins");
        $loses = mysql_result($res,$count,"loses");
        $ties = mysql_result($res,$count,"ties");

            if($week==1){
            $wins = 0;
            $loses = 0;
            $ties = 0;
        }


    echo "<td>(" . $wins ."-" . $loses . "-" . $ties[$old_count + $count] . ")</td>";
    echo "</tr>";
    }

See...I want to draw the $wins, $loses, $ties from the db but there is only one "team" field in the db and I need to draw for 2 different teams ($team1 & $team2). And I'd like for my final result to be in 2 columns like here .... http://www.pmlfootball.net/exp3.php

leatherback

Why not use one query:

$query = "select team, wins, loses, ties, pts_for, pts_agst from standings where league_id=$league_id and season=$season and ((team=\"$team2\") or (team = \"$team1\")) order by wins/(wins+loses) DESC LIMIT 1";

and get all the rsults from there? You could:

while($row=mysql_fetch_array($res))
  {
   $allresults[] = array(
    0 => $row[team],
    1 => $row[win]);
   }

and get the results from the array to create the output page? e.g. Using a foreach() statament.

eaglesfan17

What would my foreach() statement have to look like? I really stink at arrays.

leatherback

Why don't give it a try before asking? The basic idea is that you use foreach on an array.

Arrays have the structure of key, with matching value.

so: $my_array[0] refers to the first (an index typically starts with 0) value in the array $my_array.

If you use the foreach, you basically say "For each value in the array do".

so:

foreach($my_array as $mykey => $myvalue)
  {
  echo $my_key."<br>".$myvalue.;
  // insce in your case in the array, you have arrays again,. you might want to:
  print_r($myvalue);
  }