Извличане на информация от MySQL и извеждане на резултата в

[webxaoz]

Здравейте, имам нужда от малко помощ с един (php) код.
Имам база от данни и исам тези данни да се покажат в 1-на дадена таблица.
Въпроса ми е как тези данни да се изнесат в дадена таблица, какъв код трябва?.

Ето кода, където не мога да разбера къде бъркам.

<?php
$query = "SELECT * FROM contacts";
$result = mysql_query($query);
$num = mysql_numrows($result);

echo "<table border=1>
<tr>
<td>ID:</td>
<td>Fust Name:</td>
<td>Last Name:</td>
<td>Phone:</td>
<td>GSM:</td>
<td>Fax:</td>
<td>eMail:</td>
<td>Web:</td>
<td>Address:</td>
</tr>";

//
$i=0;
while ($i < $num){

$id=mysql_result($result,$i,"id");
$firstname=mysql_result($result,$i,"firstname");
$lastname=mysql_result($result,$i,"lastname");
$phone=mysql_result($result,$i,"phone");
$gsm=mysql_result($result,$i,"gsm");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");
$address=mysql_result($result,$i,"address");

echo "
<tr>
<td>$id</td>
<td>$firstname</td>
<td>$lastname</td>
<td>$phone</td>
<td>$gsm</td>
<td>$fax</td>
<td>$email</td>
<td>$web</td>
<td>$address</td>
</tr>";

//
$i++;
}

?>

 

[tedo96]

<?php
$query = "SELECT * FROM contacts";
$result = mysql_query($query);
$num = mysql_num_rows($result);

echo "<table border=1>
<tr>
<td>ID:</td>
<td>Fust Name:</td>
<td>Last Name:</td>
<td>Phone:</td>
<td>GSM:</td>
<td>Fax:</td>
<td>eMail:</td>
<td>Web:</td>
<td>Address:</td>
</tr>";

//
$i=0;
while ($i < $num){

$id=mysql_result($result,$i,"id");
$firstname=mysql_result($result,$i,"firstname");
$lastname=mysql_result($result,$i,"lastname");
$phone=mysql_result($result,$i,"phone");
$gsm=mysql_result($result,$i,"gsm");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");
$address=mysql_result($result,$i,"address");

echo "
<tr>
<td>$id</td>
<td>$firstname</td>
<td>$lastname</td>
<td>$phone</td>
<td>$gsm</td>
<td>$fax</td>
<td>$email</td>
<td>$web</td>
<td>$address</td>
</tr>";

//
$i++;
}

?>

Сега ще видя за други грешки...

 

[Fakeheal]

<?php 
$query = "SELECT * FROM contacts"; 
$result = mysql_query($query); 

echo "
<table border=1> 
	<tr> 
		<td>ID:</td> 
		<td>Fust Name:</td> 
		<td>Last Name:</td> 
		<td>Phone:</td> 
		<td>GSM:</td> 
		<td>Fax:</td> 
		<td>eMail:</td> 
		<td>Web:</td> 
		<td>Address:</td> 
	</tr>
"; 

while ($row = mysql_fetch_array($result)){ 
echo " 
	<tr> 
		<td>{$row['id']}</td> 
		<td>{$row['firstname']}</td> 
		<td>{$row['lastname']}</td> 
		<td>{$row['phone']}</td> 
		<td>{$row['gsm']}</td> 
		<td>{$row['fax']}</td> 
		<td>{$row['email']}</td> 
		<td>{$row['web']}</td> 
		<td>{$row['adress']}</td> 
	</tr>
"; 

} 

echo "
</table>
";
?>