outputting data issue

7724

Hi Guys,

I’m creating a sports content management system and am trying to figure out what to do with league fixtures. In html I have created the following html table:

Now what I want to do is have some code for each row which says something like:

Look in the ‘reports’ table in MYSQL database and if the date for each html row and opposition match the ‘date’ and ‘opposition’ of that from a record in the MYSQL database then output the F (Goals_for) and A (Goals_against) in the appropriate columns and write the word ‘report’ in the html table with a link to the report?

Now is beyond what I have done so far, so can anyone please advise? Or maybe suggest something a little easier

Chris

devinemke

during each loop iteration that outputs your HTML run a query that look like (just guessing here about your actual data structure):

SELECT report_id, Goals_for, Goals_against FROM reports WHERE date = '$date' AND opposition = '$opposition'

use the report_id in your link as a GET var to pull up the appropriate report.

7724

Thanks but still a bit stuck,

So would I create something along the lines of:

<title>Table</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="1" cellpadding="3" bgcolor="#666666">
  <tr bgcolor="#CC0000"> 
    <td valign="top" align="center" width="175"> 
      <p align="center"><b><font color="#FFFFFF">Match Date</font></b></p>
    </td>
    <td valign="top" align="left" width="356"> 
      <p align="center"><b><font color="#FFFFFF">Opposition</font></b></p>
    </td>
    <td valign="top" align="center" width="228"> 
      <p align="center"><b><font color="#FFFFFF">Competition</font></b></p>
    </td>
    <td valign="top" align="center" width="98"> 
      <p align="center"><b><font color="#FFFFFF">H/A</font></b></p>
    </td>
    <td valign="top" align="center" width="93"><b><font color="#FFFFFF">F</font></b></td>
    <td valign="top" align="center" width="93"><b><font color="#FFFFFF">A</font></b></td>
    <td valign="top" align="center" width="285"><font color="#FFFFFF"><b>Link</b></font></td>
  </tr>
  <tr bgcolor="#FFFFFF"> 
    <td width="175" height="27"> 
      <div align="center">13/08/05</div>
    </td>
    <td width="356" height="27"> 
      <div align="center">Bromsgrove Rovers </div>
    </td>
    <td width="228" height="27"> 
      <div align="center">Southern League</div>
    </td>
    <td width="98" height="27"> 
      <div align="center">Away</div>
    </td>
    <td width="93" height="27"><?php 
include("../*******.php");

$q = mysql_query("SELECT report_id, Goals_for, Goals_against 
FROM reports WHERE 13_aug = '$date' AND bromsgrove = '$opposition'") or die(mysql_error()); 

<?php echo $r['Goals_for']; ?></td>
    <td width="93" height="27"><?php 
include("../*******.php");

$q = mysql_query("SELECT report_id, Goals_for, Goals_against 
FROM reports WHERE 13_aug = '$date' AND bromsgrove = '$opposition'") or die(mysql_error()); 

<?php echo $r['Goals_againt']; ?></td>
    <td width="285" height="27">&nbsp;</td>
  </tr>
  <tr bgcolor="eeeeee"> 
    <td width="175" height="24"> 
      <div align="center">16/08/05</div>
    </td>
    <td width="356" height="24"> 
      <div align="center">Hemel Hempstead Town </div>
    </td>
    <td width="228" height="24"> 
      <div align="center">Southern League</div>
    </td>
    <td width="98" height="24"> 
      <div align="center">Home</div>
    </td>
    <td width="93" height="24"> 
<?php 
include("../*******.php");

$q = mysql_query("SELECT report_id, Goals_for, Goals_against 
FROM reports WHERE 16_aug = '$date' AND hemel = '$opposition'") or die(mysql_error()); 

<?php echo $r['Goals_for']; ?></td>
    <td width="93" height="24"> <?php 
include("../*******.php");

$q = mysql_query("SELECT report_id, Goals_for, Goals_against 
FROM reports WHERE 16_aug = '$date' AND hemel = '$opposition'") or die(mysql_error()); 

<?php echo $r['Goals_against']; ?></td>
    <td width="285" height="24">&nbsp;</td>
  </tr>
</table>
</body>
</html>

I don’t think that will work, but am I heading in the right direction(?) and how would I place a PHP tag in the ‘link’ column which says if there is a record for this output the word ‘report’ with a link to the report?

Cheers

Chris