code problem

Seandee · May 20, 2007

Hi Guys,

We have a website www.desert-rats.co.uk

I am completely new to this php stuff and have found that I can pretty much get by with editing our roster.php but I have come upon a problem.

I have edited the script to show the following table for updating through phpMYADMIN - www.desert-rats.co.uk/interclan.php

I am not able to edit the final two parts of the code to display the info inside the columns "for" "against" and "Total" - it is over my head so am wondering if you guys could help,

I only want to be able to have the info displayed under these headers,

This is the code I am working with

<?php

$mysql_table = "cp_1v1league";

$mysql_table_b = "cp_clanleague";

require_once ("required.inc.php");

getHeader();

echo "<h2 style=\"margin-bottom: 4px;\"><center>=8th= Desert Rats Batallion 1v1 Match Leagues</center></h2>";

$result = MYSQL_QUERY("SELECT * FROM $mysql_table_b ORDER BY league_id") or die (mysql_error());

$rows = mysql_num_rows($result);

if ($rows == "0") {

echo "Currently, there are no leagues available.";

}

if ($rows != "0") {

$res = mysql_query("SELECT COUNT(*) as count FROM $mysql_table") or die(mysql_error());

list($matches) = mysql_fetch_array($res);

echo "Total Matches";

echo "<table cellspacing=\"1\" cellpadding=\"2\" bgcolor=\"#4C4C4C\" width=\"91%\" style=\"margin-left: 21px; margin-top: 7px; margin-bottom: 10px;\">

<th style=\"padding-left: 6px; text-align: center;\">" . $matches . " Match" . ($matches != 1 ? 'es' : '') . " Played To Date</th>

</tr>

</table>";

$mresults = array();

$mrows = array();

$j = 0;

while ($mysql2=mysql_fetch_array($result)) {

echo "" . checkContent($mysql2[league]) . "-" . checkContent($mysql2[division]) . " Season-" . checkContent($mysql2[season]) . "";

$mresult[$mysql2[league_id]] = MYSQL_QUERY("SELECT * FROM $mysql_table WHERE league_id='$mysql2[league_id]' ORDER BY league_id") or die (mysql_error());

$mrows[$mysql2[league_id]] = mysql_num_rows($mresult[$mysql2[league_id]]);

if ($mrows[$mysql2[league_id]] == "0") {

echo "<table cellspacing=\"1\" cellpadding=\"2\" bgcolor=\"#4C4C4C\" width=\"91%\" style=\"margin-left: 21px; margin-top: 7px; margin-bottom: 10px;\">

<th style=\"padding-left: 6px; text-align: left;\">There are no matches available for this league at this time.</th>

</tr>

</table>";

} else {

echo "<table class=\"sortable\" id=\"sortable" . ++$j . "\" cellspacing=\"1\" cellpadding=\"2\" bgcolor=\"#CCCCCC\" width=\"91%\" style=\"margin-left: 21px; margin-top: 20px; margin-bottom: 30px;\">

<tr bgcolor=\"#FFFFCC\"><th width=\"18\"> </th><th width=\"100\" style=\"padding-left: 6px;\">Clan Member</th><th width=\"30\" style=\"padding-left: 6px;\">P</th><th width=\"30\" style=\"padding-left: 6px;\">W</th><th width=\"30\" style=\"padding-left: 6px;\">D</th><th width=\"30\" style=\"padding-left: 6px;\">L</th><th width=\"30\" style=\"padding-left: 6px;\">F</th><th width=\"30\" style=\"padding-left: 6px;\">A</th><th width=\"30\" style=\"padding-left: 6px;\">Total</th></tr>\n";

$i = 1;

while ($mysql=mysql_fetch_array($mresult[$mysql2[league_id]])) {

$colour = $colourone;

if ($i % 2) {

$colour = $colourtwo;

}

/* echo "

Clan Member: " . checkContent($mysql) . "

Played: " . checkContent($mysql[played]) . "

Won: " . checkContent($mysql[won]) . "

Draw: " . checkContent($mysql[draw]) . "

Lost: " . checkContent($mysql[lost]) . "

For: " . checkContent($mysql[for]) . "

Against: " . checkContent($mysql[against]) . " ";

} if ($mysql[total] != '') {

echo "<tr bgcolor=\"white\" style=\"background-image: url(img/" . ($oddeven++ % 2 ? 'even' : 'odd') . "rowbg.gif);\" height=\"14\">

<td style=\"padding-left: 6px;\">Total:</td>

<td style=\"padding-left: 9px;\">" . checkContent($mysql[total]) . "</td>

</tr>";

Total " . checkContent($mysql[total]) . " ";

*/

$color = ($mysql[result] == 'Win' ? '#1A8003' : ($mysql[result] == 'Loss' ? '#A10B0C' : ''));

echo "<tr bgcolor=\"white\" style=\"background-image: url(img/" . ($i % 2 ? 'even' : 'odd') . "rowbg.gif);\" height=\"14\">" .

"<td><span style=\"background-image: url(img/gamepics/" . urlize(checkContent($mysql[game])) . ".png); display: block; float: left; width: 18px; height: 14px; background-repeat: no-repeat; background-position: 2px 0px; \"> </td>" .

"<td style=\"text-align: left;\">" . checkContent($mysql) . "</td>" .

"<td style=\"text-align: center;\">" . checkContent($mysql[played]) . "</td>" .

"<td style=\"text-align: center;\">" . checkContent($mysql[won]) . "</td>" .

"<td style=\"text-align: center;\">" . checkContent($mysql[draw]) . "</td>" .

"<td style=\"text-align: center;\">" . checkContent($mysql[lost]) . "</td>" .

"<td style=\"text-align: center;\">" . checkContent($mysql[date]) . "</td>" .

"<td style=\"text-align: center; color: $color; text-transform: uppercase; font-weight: bold;\">" . checkContent($mysql[total]) . "</td>" .

"<td style=\"text-align: center;\">" . (($s = checkContent($mysql[total])) ? "<a href=\"$s\">View</a>" : " ") . "</td>" .

"</tr>\n";

$i++;

}

echo "</table>";

}

getFooter();

?>

Please help if you can

All the best ..... Sean.

Seandee · May 20, 2007

Hi Sorry the link to it is www.desert-rats.co.uk/interclan1.php

Sign In

code problem

Recommended Posts

Seandee

Link to comment

Share on other sites

Seandee

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information