Forum Moderators: coopster
Thanks in advance and sorry for my bad english
a href="add.php">Adauga apartament nou</a><br>
<br>
<?phpinclude("connect.php");
$query="SELECT * FROM apartamente ";
$result=mysql_query($query);
$num = mysql_num_rows ($result);
mysql_close();
if ($num > 0 ) {
$i=0;
while ($i < $num) {
$tip = mysql_result($result,$i,"tip");
$nr_camere = mysql_result($result,$i,"nr_camere");
$zona = mysql_result($result,$i,"zona");
$adresa = mysql_result($result,$i,"adresa");
$confort = mysql_result($result,$i,"confort");
$etaj = mysql_result($result,$i,"etaj");
$suprtotala = mysql_result($result,$i,"suprtotala");
$suprutila = mysql_result($result,$i,"suprutila");
$an_constructie = mysql_result($result,$i,"an_constructie");
$vedere = mysql_result($result,$i,"vedere");
$orientare = mysql_result($result,$i,"orientare");
$nr_gr_sanitare = mysql_result($result,$i,"nr_gr_sanitare");
$nr_balcoane = mysql_result($result,$i,"nr_balcoane");
$bulina = mysql_result($result,$i,"bulina");
$cadastru_intabulare = mysql_result($result,$i,"cadastru_intabulare");
$descriere = mysql_result($result,$i,"descriere");
$pret = mysql_result($result,$i,"pret");
$id = mysql_result($result,$i,"id");
echo "<td><b>Tip:</b> $tip<br></td>";
echo "<b>Nr. Camere:</b> $nr_camere<br>";
echo "<b>Zona</b> $zona<br>";
echo "<b>Adresa:</b> $adresa<br>";
echo "<b>Confortt:</b> $confort<br>";
echo "<b>Etaj:</b> $etaj<br>";
echo "<b>Suprafata Totala:</b> $suprtotala<br>";
echo "<b>Suprafata Utila:</b> $suprutila<br>";
echo "<b>An Constructie:</b> $an_constructie<br>";
echo "<b>Vedere:</b> $vedere<br>";
echo "<b>Orientare:</b> $orientare<br>";
echo "<b>Nr. Grupuri Sanitare:</b> $nr_gr_sanitare<br>";
echo "<b>Nr. Balcoane:</b> $nr_balcoane<br>";
echo "<b>Bulina:</b> $bulina<br>";
echo "<b>Cadastru/Intabulare:</b> $cadastru_intabulare<br>";
echo "<b>Descriere:</b> $descriere<br>";
echo "<b>Pret:</b> $pret<br>";
echo "<a href=\"update.php?id=$id\">Update</a> - <a href=\"delete.php?id=$id\">Delete</a>";
echo "<br><br>";
++$i; } } else { echo "Baza de date este Goala"; }?>
include("connect.php");
$query="SELECT * FROM apartamente ";
$result=mysql_query($query);
$num = mysql_num_rows ($result);
mysql_close();
if ($num > 0 ) {
$i=0;
while ($i < $num) {
$tip = mysql_result($result,$i,"tip");
$nr_camere = mysql_result($result,$i,"nr_camere");
$zona = mysql_result($result,$i,"zona");
$adresa = mysql_result($result,$i,"adresa");
$confort = mysql_result($result,$i,"confort");
$etaj = mysql_result($result,$i,"etaj");
$suprtotala = mysql_result($result,$i,"suprtotala");
$suprutila = mysql_result($result,$i,"suprutila");
$an_constructie = mysql_result($result,$i,"an_constructie");
$vedere = mysql_result($result,$i,"vedere");
$orientare = mysql_result($result,$i,"orientare");
$nr_gr_sanitare = mysql_result($result,$i,"nr_gr_sanitare");
$nr_balcoane = mysql_result($result,$i,"nr_balcoane");
$bulina = mysql_result($result,$i,"bulina");
$cadastru_intabulare = mysql_result($result,$i,"cadastru_intabulare");
$descriere = mysql_result($result,$i,"descriere");
$pret = mysql_result($result,$i,"pret");
$id = mysql_result($result,$i,"id");
?>
<table>
<tr><td>Tip:</td><td><?=$tip?></td></tr>
<tr><td>Nr. Camere:</td><td><?=$nr_camere?></td></tr>
<!-- In the same way all your data -->
</table>
<?php
++$i; } } else { echo "Baza de date este Goala"; }
?>
++$i; } } else { echo "Baza de date este Goala"; }?>