CMS Made Simple Forums

Code: Select all

require "http://www.wientanz.com/mitarbeiter/gabriel/datenbank/include/functions.inc";


echo "<div align=center>";

  $res=mysql_query("select count(*) from ball;");
  $arr=mysql_fetch_array($res);

  $res2=mysql_query("select * from probe group by P_B_ID;");
  
  
  echo "<p><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\">Derzeit haben 
    wir <b>$arr[0]</b> in unserer Liste, davon <b>".mysql_affected_rows()."</b> 
    mit Eröffnungsinformationen.</font></p>"; 
  
  
  echo "<hr>";
  
  $res = mysql_query("select B_ID, B_Desc, B_Date, B_Ort, B_Price, B_Info, B_EMail, month(B_Date), year(B_Date) from ball ORDER BY B_Date;");
  
  $month=13;
  $first=1;
  
  
  
  echo "<table width=\"750\" border=\"0\">";
  while($arr=mysql_fetch_array($res)) {
     if($month!=$arr[7]) {	//Print new TableHeader
        $month=$arr[7];
        $duo=1; 
        
        
        

   
           echo "<tr><td> </td></tr> 	
    	   <tr bgcolor='#000066' bordercolor='#000066'> 
      		<td colspan='6'> 
        		<div align='center'><font size='3' color='#FFFFFF'><b><font face='Arial, Helvetica, sans-serif'><i>";
				 echo get_full_month($arr[7])." $arr[8]"; echo " </i></font></b></font></div>
      		</td>
    	   </tr>
    	   <tr bgcolor=#000066> 
	      <td bordercolor=#000066><b><font color=#FFFFFF>Datum</font></b></td>
	      <td bordercolor=#000066><b><font color=#FFFFFF>Ball</font></b></td>
	      <td bordercolor=#000066><b><font color=#FFFFFF>Ort</font></b></td>
	      <td bordercolor=#000066><b><font color=#FFFFFF>Kartenpreise</font></b></td>
	      <td bordercolor=#000066><b><font color=#FFFFFF>Telefonnummer</font></b></td>
	      <td bordercolor=#000066><b><font color=#FFFFFF>Probeninfo</font></b></td>
	   </tr>";
  
    
    
    
        }			//End of TableHead
     if($duo%2==0) $color="#99CCFF";
     else $color="#0099FF";
     $duo++;
     
     echo "<tr bgcolor=\"$color\">";    
     echo " <td bordercolor=\"$color\"><font size=\"2\" face=\"Geneva, Arial, Helvetica, san-serif\">".get_na_string($arr[2])."</font></td>";  
     echo " <td bordercolor=\"$color\"><font size=\"2\" face=\"Geneva, Arial, Helvetica, san-serif\">".get_na_string($arr[1])."</font></td>";     
     echo " <td bordercolor=\"$color\"><font size=\"2\" face=\"Geneva, Arial, Helvetica, san-serif\">".get_na_string($arr[3])."</font></td>";     
     echo " <td bordercolor=\"$color\"><font size=\"2\" face=\"Geneva, Arial, Helvetica, san-serif\">".get_na_string($arr[4])."</font></td>";  
     echo " <td bordercolor=\"$color\"><font size=\"2\" face=\"Geneva, Arial, Helvetica, san-serif\">".get_na_string($arr[5])."</font></td>";     
     echo " <td bordercolor=\"$color\"><font size=\"2\" face=\"Geneva, Arial, Helvetica, san-serif\">";

     $res2=mysql_query("select P_Link FROM probe where p_b_id='$arr[0]';");
     if(!$arr2=mysql_fetch_array($res2)) 
        echo "N/A"; 
     elseif(strlen($arr2[0])>1) echo "<a href=\"$arr2[0]\">Info</a>";
     else echo "<a href=\"http://www.wientanz.com/mitarbeiter/gabriel/datenbank/ballinfo.php?B_ID=$arr[0]\">Proben</a>";


     echo "</font></td>";        
     echo "<tr>";   
     }
  echo "</table>
     <br><hr><br>
     
   
  <p><font size='2'>Datenbank wurde zuletzt aktualisiert: "; echo get_last_change();  echo "</font> </p>
  <p> </p>
  <p> </p>
</div>";