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(); ?>