[Resolved] More economical coding

ali_p

Hello,
I am looking for a more economical way to display the code below. What i have is ok for 1 group but i will need to run the same query over and over for about another 7 groups ( Group A to Group H). Can anyone suggest a neater way of obtaining the same results.

Thanks

//open the connection
$conn = mysql_connect("$glob_host", "$glob_user", "$glob_pass");

mysql_select_db($db_name, $conn);
//create the sql statement for all the games in Group C
$sql = "SELECT * 
		FROM dcass_games
		WHERE team1_result = 'tbc'
		AND xgroup = 'Group C'
		ORDER BY game_date DESC";

$result = mysql_query($sql, $conn)or die(mysql_error());
// Set a variable to display results on screen later
$display_block = "";
$count=0;
//will go through each row in the result set and display data
	while ($row = mysql_fetch_array($result)) {
	//give a name to the fields
	$group = $row['xgroup'];
	$tournament = $row['tournment'];
	$game_date=$row['game_date'];
	$venue=$row['venue'];
	$team1=$row['team1'];
	$team2=$row['team2'];
	$team1_result=$row['team1_result'];
	$team2_result=$row['team2_result'];
	$game_id = $row['game_id'];
    $display_blockc .= "<table width=\"400\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"content\"><tr><td width=\"50\">$game_date</td><td width=\"150\">$team1</td><td width=\"25\">V</td><td width=\"150\">$team2</td></tr></table>
	";
}

devinemke

$conn = mysql_connect($glob_host, $glob_user, $glob_pass) or die(mysql_error());
mysql_select_db($db_name, $conn) or die(mysql_error());
$sql = "SELECT * FROM dcass_games WHERE team1_result = 'tbc' ORDER BY game_date DESC";
$result = mysql_query($sql, $conn) or die(mysql_error());

$display_block = '
<table width="400" border="0" cellspacing="0" cellpadding="0" class="content">
<tr>
<td><b>Group</b></td>
<td><b>Game Date</b></td>
<td><b>Team 1</b></td>
<td><b>Team 2</b></td>
</tr>
';

while ($row = mysql_fetch_assoc($result))
{
    $display_block .= '
    <tr>
    <td>' . $row['xgroup'] . '</td>
    <td>' . $row['game_date'] . '</td>
    <td>' . $row['team1'] . '</td>
    <td>' . $row['team2'] . '</td>
    </tr>
    ';
}

$display_block .= '</table>';

ali_p

Many thanks for the help.
But what i am really looking for is for the results to be displyed more like this

GROUP B
12-11-2005 New Zealand V Germany
12-05-2005 Lapland V Costa Rica

GROUP C
12-11-2005 Brazil V Portugal
12-05-2005 Scotland V Denmark
12-05-2005 Belgium V France

Where all the Group Cs are grouped together as will be Group A through to H. Basically the Group is only displsyed once.

devinemke

$conn = mysql_connect($glob_host, $glob_user, $glob_pass) or die(mysql_error());
mysql_select_db($db_name, $conn) or die(mysql_error());
$sql = "SELECT * FROM dcass_games WHERE team1_result = 'tbc' ORDER BY game_date DESC";
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {$array[$row['xgroup']][] = $row;}

$display_block = '';

foreach ($array as $key => $value)
{
    $display_block .= $key . '<br>';
    foreach ($value as $row)
    {
        $display_block .= $row['game_date'] . ' ' . $row['team1'] . ' V ' . $row['team2'] . '<br>';
    }
    $display_block .= '<br>';
}

ali_p

Thats brilliant and spot on.
I thank you.