Giocatori DTB
Foto DTB
$fotointerne = mysql_query("SELECT *,
count AS conteggio
FROM tags
ORDER BY name
",$connection)
or die(mysql_error());
while($data = mysql_fetch_array($fotointerne))
{
$stringa = $data[name];
// Utilizziamo due vettori di pari dimensioni
$origi = array(
"'",
"x"
);
$copia = array(
"",
""
);
$search = str_replace( $origi, $copia, $stringa );
$conteggio = $data[conteggio];
$foto = mysql_query("SELECT C.*
FROM tags A,
items_tags B,
items C,
users D
WHERE A.name LIKE '%$search%' AND
A.id = B.tag_id AND
C.id = B.item_id AND
C.owner_id = D.id
ORDER BY RAND()
LIMIT 1
",$connection)
or die(mysql_error());
while($data = mysql_fetch_array($foto))
{
$album = mysql_query("SELECT name
FROM items
WHERE id = '$data[parent_id]'
ORDER BY created
",$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;
";
$caption_span = "
font-family: Verdana, sans-serif;
font-size: 10px;
font-weight: bold;
height:8px;
min-height:8px;
margin-top: 90px;
margin-right: 0px;
margin-bottom: 45px;
margin-left: -22px;
padding: 24px;
width: 100%;
color: #dedede;
position: absolute;
left: 0;
bottom: 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;
";
$caption_span = "
font-family: Verdana, sans-serif;
font-size: 10px;
font-weight: bold;
height:30px;
min-height:20px;
margin-top: 40px;
margin-right: 70px;
margin-bottom: 10px;
margin-left: 50px;
padding: 0px;
width: 100%;
color: #dedede;
position: absolute;
left: 0;
bottom: 0;
";
}
?>
}
}
mysql_free_result($foto);
mysql_free_result($album);
mysql_free_result($fotointerne);
?>