<?php


echo '<table width="555" border="1">';
echo '<tr>
<th width="100" scope="col">ID</th>
<th width="271" scope="col">FIO</th>
<th width="131" scope="col">DR </th>
<th width="100" scope="col">Telefon</th>
<th width="131" scope="col">Adres </th>
<th width="271" scope="col">Doljnost</th>
<th width="100" scope="col">Consultant </th>
<th width="131" scope="col">Dop.Information</th>
</tr>';

include "config.php";
$query= "SELECT IDclient,name_client,DATE_FORMAT(dr,'%d.%m.%Y') AS dr,telefon,adres,work,IDconsul,dopinfo FROM clients";//}
$cat= mysql_query($query);
while ($row = mysql_fetch_assoc($cat))
{

echo "<tr>
<td>".$row ['IDclient']."</td>
<td>".$row ['name_client']."</td>
<td>".$row ['dr']."</td>
<td>".$row ['telefon']."</td>
<td>".$row ['adres']."</td>
<td>".$row ['work']."</td>
<td>".$row ['IDconsul']."</td>
<td>".$row ['dopinfo']."</td>
<td><select name=\"menu1\">
<option value=\"1\">1</option>
<option value=\"2\">2</option>
<option value=\"3\">3</option>
<option value=\"4\">4</option>
</select></td>
</tr>";

}
echo "</table>";
?>

echo "<tr>
<td>".$row ['IDclient']."</td>
<td>".$row ['name_client']."</td>
<td>".$row ['dr']."</td>
<td>".$row ['telefon']."</td>
<td>".$row ['adres']."</td>
<td>".$row ['work']."</td>
<td>".$row ['IDconsul']."</td>
<td>".$row ['dopinfo']."</td>
<td><select name=\"menu".$row ['IDclient']."\">";
$q= "SELECT IDcon,namecon FROM consultant";//}
$a= mysql_query($q);
while ($a = mysql_fetch_assoc($q))
{
echo "<option value=\"".$a['IDcon']."\">".$a['namecon']."</option>";
}
echo "</select></td>
</tr>";

}

while ($f = mysql_fetch_assoc($a))
{
echo "<option value=\"".$f['IDcon']."\">".$f['namecon']."</option>";
}