. ( ) 2 . . 2 . , . . . .





<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html;charset=windows-1251" />
<title>MUSIC CATALOGUE</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<h1> LINK BETWEEN THE TWO TABLES <h1>
<hr>
<?php
require("connect.php");
$link = new connection();
$link->connect();
$products=mysql_query("select * from products ORDER BY id ASC");
?>
<div id="body">
<table class="gridtable" align="center" width="800">
<tr>
<?php

while ($row = mysql_fetch_assoc($products)) {
?>
<td>
// Php :S
<input type="checkbox" >
<input name="" type="submit">

<h3><?php echo $row['name']; ?></h3></td>
<td rowspan="2" valign="top"><img width="300" height="200" src="get_img.php?table=products&field=pi c&id=<?php echo $row["id"]; ?>"></td>
</tr>
<tr>
<td><?php echo $row['text']; ?></td>
</tr>
<tr>

<td><h3 ><font color="#336699">:</font></h3></td>
<td><h3><?php echo $row['price']; ?></h3></td>
</tr>
<tr>
</tr>
<?php } ?>
</table>

</div>
<br>
</div>
<br>
</div>
<br><br>
</body>
</html>