$squadraID = $_GET['squadraID']; ?> $tor = $_GET['tor']; ?> include('getsex.php'); ?>
$get_squadra = mysql_query("SELECT
B.campo_nick AS nick,
B.campo_citta AS citta,
DATE_FORMAT(B.campo_data_inizio, '%Y') AS anos,
A.OpponentID AS idsquadra,
A.OpponentName AS nomesquadra
FROM $opponents A, dt_campo B
WHERE B.campo_ID = A.Opponenttor AND
A.OpponentID = '$squadraID'
",$connection)
or die(mysql_error());
$i=1;
if(mysql_num_rows($get_squadra) < 1)
{
?>
Squadre non trovata
} else {
?>
while($data = mysql_fetch_array($get_squadra))
{
$squadra = $data[idsquadra];
$nomesquadra = addslashes($data[nomesquadra]);
$nick = addslashes($data[nick]);
$cittatorneo = $data[citta];
?>
mysql_free_result($get_giocatori);
?>
}
// mysql_free_result($fotointerne);
}
?>
echo $data[nomesquadra]; ?> |
|
---|---|
echo $data[gio_cognome]." ".$data[nome]; ?> | |
$foto = mysql_query("SELECT C.*, B.item_id FROM tags A, items_tags B, items C WHERE A.name LIKE '%$cognome_nome%' AND A.id = B.tag_id AND C.id = B.item_id ORDER BY RAND() ",$connection) or die(mysql_error()); while($data = mysql_fetch_array($foto)) { $album = mysql_query("SELECT * FROM items WHERE id = '$data[item_id]' ",$connection) or die(mysql_error()); if ($data[resize_height] == 640) {$style = " height:auto !important; height:120px; min-height:120px; width:auto !important; width:110px; min-width:110px; margin-top: -40px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding:0; border:0; ";} if ($data[resize_width] == 640) {$style = " height:auto !important; height:110px; min-height:110px; width:auto !important; width:120px; min-width:120px; margin-top: -30px; margin-right: -70px; margin-bottom: -10px; margin-left: -50px; padding:0; border:0; ";} ?> } // mysql_free_result($foto); // mysql_free_result($album); ?> echo $data[gio_cognome]." ".$data[nome]; ?> | } ?>