echo "<p><center>Товары</p></center>";

echo "<center>";
$link = mysql_connect("localhost", "root", "") or die ("Нет соединения с хостом");
mysql_select_db ("svyaznoy");
$query = mysql_query("SELECT idt,nametovar,opis,kat,proizv FROM tovar left join proizv on tovar.idp=proizv.idp left join kat on tovar.idk=kat.idk ") or die(mysql_error());
$number = mysql_num_rows($query );

$query2 = "SELECT idk,kat  FROM kat ";
$res2 = mysql_query($query2) or die(mysql_error());
$number2 = mysql_num_rows($res2);


$query3 = "SELECT idp,proizv  FROM proizv";
$res3 = mysql_query($query3) or die(mysql_error());
$number3 = mysql_num_rows($res3);

 if ($number == 0) {echo "<CENTER>Нет данных для корреции</CENTER>";} 

echo "<table border='1'><tr><td>Код товара</td><td>Наименование товара</td><td>Краткое описание</td><td>Категория</td><td>Производитель</td><td>Удалить</td><td>Редактировать</td><td>Новое значение</td></tr>";
while($row = mysql_fetch_array($query))
    {  echo "<tr>
                <td>{$row['0']}</td>
                <td>{$row['1']}</td>
		<td>{$row['2']}</td>
	<td>{$row['3']}</td>
	<td>{$row['4']}</td>

    <form method='post' action=''>
                         <td><input name='del' type='submit' value='Удалить'></td>
                        <td> <input name='red' type='submit' value='Редактировать'></td>
         <input name='id' type='hidden' value='". $row['0'] ."'> 
                       <td>     <input  name='namered' type='text' value='". $row['1'] ."'>
                       <input  name='opisred' type='text'  size='100' maxlength='255'  value='". $row['2'] ."'>

<select name='vibor'  maxlength='155'>";

while ($row2=mysql_fetch_array($res2)) 
{echo "<option value=".$row2['idk'].">".$row2['kat']."</option>";}
echo "</select>
       </td> </form>
              
        </tr>";

};