Jump to content

display all records

netman182

By netman182
in PHP Coding Help

 Share

Recommended Posts

netman182 Member

netman182

Posted
Posted

I am trying to make automated scoresheets for a soccer league. The problem i am having is it is only displaying the first record and repeating.

 

Could someone please help me out with this?

 

 

Thanks in advance.

 

<?php
/* connection and protection */
include 'dbc.php';

// MATCH DATA
$details = mysql_query("SELECT * FROM thirdsched_south WHERE id = '1'")
or die(mysql_error());  

// matchs data
$match = mysql_fetch_array( $details );


// HOME TEAM
$hometeam = mysql_query("SELECT * FROM players WHERE teamid = 'cloverda' AND approved ='1'")
or die(mysql_error());  

// store home data
$home = mysql_fetch_array( $hometeam );

// AWAY TEAM
$awayteam = mysql_query("SELECT * FROM players WHERE teamid = 'lefcb' AND approved ='1'")
or die(mysql_error());  

// Store AWAY DATA
$away = mysql_fetch_array( $awayteam );
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script type="text/javascript" src="public_smo_scripts.js"></script>
<link href="styles.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {
font-family: Geneva, Arial, Helvetica, sans-serif;
font-size: 13px;
}
.style2 {font-size: 14px}
.style3 {font-family: Geneva, Arial, Helvetica, sans-serif; font-size: 14px; }
-->
</style>
</head>

<body onload="window.print()">
<table width="930" border="1">    <tr>
    <td colspan="2" class="style1 style1"><div align="center"><img src="bccsl-gmsh-hd.jpg"/></div></td>
  </tr>
</table>
<table width="930" border="1">
  <tr>
    <td width="455" class="style1 style1"><div align="center" class="style2">Division: Third- South</div></td>
    <td width="459" height="32" class="style1 style1"><div align="center" class="style2">Date: <? echo $match['date']; ?> </div></td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center" class="style2">Time: <? echo $match['time']; ?> </div></td>
    <td height="36" class="style1 style1"><div align="center" class="style2">Field: <? echo $match['field']; ?> </div></td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center" class="style2">Home Team: <? echo $match['hometeam']; ?>  </div></td>
    <td class="style1 style1"><div align="center" class="style2">Away Team: <? echo $match['awayteam']; ?></div></td>
  </tr>
</table>
<table width="930" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <th width="230" class="style1 style1" scope="col"><div align="center">Name</div></th>
    <th width="41" class="style1 style1" scope="col">#</th>
    <th width="41" class="style1 style1" scope="col">G</th>
    <th width="41" class="style1 style1" scope="col">A</th>
    <th width="71" class="style1 style1" scope="col">Cards</th>
    <th width="47" rowspan="38" class="style1 style1" scope="col"><img src="bccsl-gmsh-MD.jpg" width="47" height="657" /></th>
    <th width="227" class="style1 style1" scope="col"><div align="center">Name</div></th>
    <th width="46" class="style1 style1" scope="col">#</th>
    <th width="46" class="style1 style1" scope="col">G</th>
    <th width="43" class="style1 style1" scope="col">A</th>
    <th width="73" class="style1 style1" scope="col">C</th>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first'];?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
   <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
  <tr>
    <td class="style1 style1"><div align="center"><? echo $home['first']; ?> <? echo $home['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center"><? echo $away['first'];?> <? echo $away['last'];?></div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
   <tr>
    <td bgcolor="#666666" class="style1 style1"><div align="center"></div></td>
    <td bgcolor="#666666" class="style1 style1"> </td>
    <td bgcolor="#666666" class="style1 style1"> </td>
    <td bgcolor="#666666" class="style1 style1"> </td>
    <td bgcolor="#666666" class="style1 style1"> </td>
    <td bgcolor="#666666" class="style1 style1"><div align="center"></div></td>
    <td bgcolor="#666666" class="style1 style1"> </td>
    <td bgcolor="#666666" class="style1 style1"> </td>
    <td bgcolor="#666666" class="style1 style1"> </td>
    <td bgcolor="#666666" class="style1 style1"> </td>
  </tr>
  <tr>
    <td height="43" class="style1 style1"><div align="center" class="style2">TOTALS</div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"><div align="center" class="style2">TOTALS</div></td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
    <td class="style1 style1"> </td>
  </tr>
</table>
<table width="930" border="1">
  <tr>
    <td width="447" class="style3">MANAGERS<br />
  SIGNATURE:_______________________________</td>
    <td width="467" class="style1"><p class="style2">MANAGERS<br />
    SIGNATURE:________________________________</p></td>
  </tr>
  <tr>
    <td height="48" class="style1"><p class="style2">REFEREE<br />
  SIGNATURE:_______________________________</p>    </td>
    <td class="style1 style2">REFFEREE<br />
    COMMENTS:</td>
  </tr>
  <tr>
    <td colspan="3" class="style1 style1"><div align="center" class="style2">Game Report is due within 24hrs. Email Report to [email protected] or fax to 604-677-5846</div></td>
  </tr>
</table>
</body>
</html>

Link to comment
https://forums.phpfreaks.com/topic/233034-display-all-records/
Share on other sites
netman182 Member

netman182

Posted
  • Author
Posted

i need to have an answer by 11 am PST. Our league is willing to pay $250 to someone who will help us out with the problem. it boils down to too much stuff to do and too little time to prepare for our opening night.

 

 

please email me: [email protected] and i will put you in contact with our treasurer.

 

thanks

Link to comment
https://forums.phpfreaks.com/topic/233034-display-all-records/#findComment-1198697
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.