Forum Moderators: coopster

Message Too Old, No Replies

echo in a table

         

AlexandruStefan

12:47 pm on Jul 10, 2009 (gmt 0)

10+ Year Member



Hy everyone, i have a little question about echoing in table
i want to make a table who contains all echo from my code
this is the code

Thanks in advance and sorry for my bad english

a href="add.php">Adauga apartament nou</a><br>
<br>
<?php

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");

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"; }?>

abidshahzad4u

2:06 pm on Jul 10, 2009 (gmt 0)

10+ Year Member



<?php

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"; }?>

AlexandruStefan

2:46 pm on Jul 10, 2009 (gmt 0)

10+ Year Member



Thanks a lot!