include("../admin/db-info.php");
include("../admin/db-con.php");
$query = mysql_query("SELECT COUNT(id) AS totuna FROM unitati WHERE tip='casa' AND aprobat='da'");
$noc=mysql_result($query,0,"totuna");
$query = mysql_query("SELECT COUNT(id) AS totuna FROM unitati WHERE tip='apartament' AND aprobat='da'");
$noa=mysql_result($query,0,"totuna");
$query = mysql_query("SELECT COUNT(id) AS totuna FROM unitati WHERE tip='hotel' AND aprobat='da'");
$noh=mysql_result($query,0,"totuna");
$query = mysql_query("SELECT COUNT(id) AS totuna FROM unitati WHERE tip='pensiune' AND aprobat='da'");
$nop=mysql_result($query,0,"totuna");
$sintaxa = "SELECT * FROM unitati WHERE tip='hotel' AND aprobat='da'";
$query = mysql_query("$sintaxa");
$num = mysql_numrows($query);
$i=0;
while ($i<$num) {
$id[$i]=mysql_result($query,$i,"id");
$nume[$i]=mysql_result($query,$i,"nume");
$introducere[$i]=mysql_result($query,$i,"introducere");
++$i; }
mysql_close();
?>