prueba

{source}
<?php
$host = «localhost»;
$dbUser = «wwwwalk_pbsadmin»;
$dbPassword = «pbspassword54075»;
$dbName = «wwwwalk_pbstest»;
$db = mysql_connect($host, $dbUser,$dbPassword) or die ( ‘Unable to connect to server.’ );;
mysql_select_db($dbName,$db) or die ( ‘Unable to select database.’ );

$gm_bxscr_arr = mysql_query(«SELECT * FROM calendario WHERE gameID=22 «,$db);
$gmsScrRow = mysql_fetch_array($gm_bxscr_arr);

$visitorid = $gmsScrRow[visitorID];
$localid = $gmsScrRow[localID];

$gm_teams_arr = mysql_query(«SELECT team.club_medio FROM team WHERE team.teamID=$visitorid«,$db);
$visitor = mysql_fetch_array($gm_teams_arr);
$visitante = $visitor[club_medio];

$gm_teams_arr = mysql_query(«SELECT team.club_medio FROM team WHERE team.teamID=$localid«,$db);
$local_d = mysql_fetch_array($gm_teams_arr);
$local = $local_d[club_medio];

?>
<table width=«600»>
<tr>
<td> </td>

</tr>
<tr>
<td>
<!–– visitnate jugID=$Batter[$cont] ––>
<table width=«100%« >
<tr>
<td width=«39%«>Bateador</td>
<td width=«9%«>Pos</td>
<td width=«8%«>TB</td>
<td width=«9%«>CA</td>
<td width=«9%«>H</td>
<td width=«10%«>CI</td>
<td width=«8%«>BB</td>
<td width=«8%«>SO</td>
</tr>

<?php
$gm_pbp_con = mysql_query(«SELECT DISTINCT jugID FROM gameplays WHERE gameID = 22 AND equID= $visitorid«,$db);
$pbp_rows = mysql_fetch_array($gm_pbp_con);

do{
$Batter[$cont] = $pbp_rows[jugID];
/* $Equi[$cont] = $pbp_rows[equID]; */

$gm_bs_wn_arr = mysql_query(«SELECT * FROM players WHERE players.playerID=$Batter[$cont]«,$db);
$gmswnRow = mysql_fetch_array($gm_bs_wn_arr);

$bateador[$cont] = $gmswnRow[first].» «.$gmswnRow[last];

$vab_sql = mysql_query(«SELECT count(jugID) AS Vab FROM gameplays WHERE gameID = 22 AND equID= $visitorid«,$db);
$vab_arr = mysql_fetch_array($vab_sql);
$vab = $vab_arr[Vab];

$ca_sql = mysql_query(«SELECT jugID,count(hom) AS Ca FROM gameplays WHERE gameID = 22 AND equID= $visitorid GROUP BY jugID= $Batter[$cont] HAVING hom>0″,$db);
$ca_arr = mysql_fetch_array($ca_sql);
$ca = $ca_arr[Ca];

$hit_sql = mysql_query(«SELECT jugID,count(plays) AS Hit FROM gameplays WHERE gameID = 22 AND equID= $visitorid GROUP BY jugID= $Batter[$cont] HAVING plays=1 OR plays=2 OR plays=3 OR plays=4″,$db);
$hit_arr = mysql_fetch_array($hit_sql);
$hit = $hit_arr[Hit];

echo ‘<tr>
<td>‘.$bateador[$cont].‘</td>
<td> </td>
<td>‘.$vab.‘</td>
<td>‘.$ca.‘</td>
<td>‘.$hit.‘</td>
<td>‘.$vab.‘</td>
<td>‘.$vab.‘</td>
<td>‘.$ca.‘</td>
</tr>‘;

$cont++;
}while ($gmswnRow = mysql_fetch_array($gm_bs_wn_arr););

?>

</table>
<!–– ddddddddddddd ––>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<!–– local ––>

<table width=«100%« >
<tr>
<td>Bateador</td>
<td>Pos</td>
<td>TB</td>
<td>CA</td>
<td>H</td>
<td>CI</td>
<td>BB</td>
<td>SO</td>
</tr>
<tr>
<td width=«39%«> </td>
<td width=«9%«> </td>
<td width=«8%«> </td>
<td width=«9%«> </td>
<td width=«9%«> </td>
<td width=«10%«> </td>
<td width=«8%«> </td>
<td width=«8%«> </td>
</tr>
</table>
<!–– ddddddddddddd ––>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table>
{/source}