public function editPharmacyInfo($ID)
{
$newpharmacy = new Pharmacy();
$rs = mysql_query("SELECT u.UserName,p.Name,p.PhoneNumber,p.Address FROM pharmacy p,user u where u.ID=p.ID and u.ID='" . $ID . "'");
$row = mysql_fetch_assoc($rs);
echo '<form method="post" action="' . $newpharmacy->editPharmacy($ID) . '">';
?>
<table>
<tr>
<td>
اسم المستخدم
</td>
<td>
<?php
echo '<input name="UserName" type="text" value="' . $row['UserName'] . '" />*';
?>
</td>
</tr>
<tr>
<td>
الاسم
</td>
<td>
<?php
echo '<input name="Name" type="text" value="' . $row['Name'] . '" />*';
?>
</td>
</tr>
<tr>
<td>
رقم الهاتف
</td>
<td>
<?php
echo '<input name="PhoneNumber" type="text" value="' . $row['PhoneNumber'] . '" />*';
?>
</td>
</tr>
<tr>
<td>
العنوان
</td>
<td>
<?php
echo '<input name="Address" type="text" value="' . $row['Address'] . '" />*';
?>
</td>
</tr>
</table>
<?php
echo '<input name="editPharmacy" type="submit" value="تعديل" />';
echo '</form>';
}