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>';
    }