稲毛FC 2002年組

“;

$conn = mysql_connect(‘mysql31.heteml.jp’,’_inage2′,’tade2212′) or die(mysql_error());
mysql_select_db(‘_inage2’) or die(mysql_error());

$sql = “select * from taikai, result where taikai.id = result.taikai_id order by taikai.date desc;”;
$res = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_assoc($res)){
if($row[taikai_id] != $old_id){
$old_id = $row[taikai_id];
if( $cnt =! 0 )
{
$list .= “

“;
$cnt++;
}

$list .= “

“;
$list .= “

“;
$list .= “

“;
$list .= “

“;
$list .= “

“;
$list .= “

“;
$list .= “

“;
$list .= “

“;
$list .= “

“;
$list .= “

“;
$list .= “

“;
$list .= “

“;
}

if( $row[mark] == 1 ) $mark_text =”○”;
elseif( $row[mark] == 2 ) $mark_text =”●”;
else $mark_text =”△”;

$list .= “

“;
$list .= “

“;
$list .= “

“;
}
$list .= “

“.$row[date].”			“.$row[event].”
“.$row[result].”			“.$row[win].” 勝 “.$row[rose].” 敗 “.$row[draw].” 分
“.$row[comment].”
“.$row[‘opponent’].”			“.$row[‘goal’].” – “.$row[‘lost’].”		“.$mark_text.”

“;
$list .= “