Защо не ми изкарва всички резултати, а само последния
Код:
<?php include("conn.php"); ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<title></title>
<style type="text/css">
</style>
</head>
<body>
<?php
$r = @mysql_select_db("links", $connect)
or die(mysql_error());
$zaiavka="select * from link";
$r = mysql_query($zaiavka, $connect)
or die(mysql_error());
while($row=mysql_fetch_array($r))
{
$list = "<tr>
<td width=\"50\">$row[id]</td>
<td width=\"100\"><a href=\"$row[link]\" target=\"_blank\"><img src=\"$row[url]\" alt=\"\" border=\"0\"></a></td>
<td width=\"200\">$row[desk]</td>
<td width=\"100\">$row[cat]</td>
</tr>";
}
?>
<table width="450" border="1" align="center" cellpadding="1" cellspacing="1">
<tr>
<td width="50">ID</td>
<td width="100">Site</td>
<td width="150">Description</td>
<td width="100">Category</td>
</tr>
<?php echo $list; ?>
</table>
</body>
</html>