";
include(ROOT_DIR."/ture/conectare.php");
// nr de zile si poze
$query="SELECT * FROM statistici";
$result=mysql_query($query) or die("Eroare: ".$query);
while ($row=mysql_fetch_object($result))
{
echo "In $row->total_zile zile ";
echo "ai facut $row->total_poze poze ";
}
// numarul de locatii distincte
$query="SELECT COUNT(DISTINCT ture.locatia) FROM ture";
$result=mysql_query($query) or die("Eroare");
$num_rows = mysql_result($result,0,0);
echo "in $num_rows de locatii diferite.
";
// nr. de ture pentru fiecare locatie
$query="SELECT DISTINCT ture.locatia FROM ture";
$result=mysql_query($query) or die("Eroare");
while ($row=mysql_fetch_object($result))
{
$query1="SELECT count(*) FROM ture WHERE locatia LIKE '%$row->locatia%'";
$result1=mysql_query($query1) or die("Eroare");
$num_rows1 = mysql_result($result1,0,0);
if ($num_rows1==1) echo "In ".strtoupper($row->locatia)." ai fost o data
";
else echo "In ".strtoupper($row->locatia)." ai fost de $num_rows1 ori
";
}
?>