السلام عليكم
كتبت كود تحديث بيانات لصف مخزن في الداتابيس يقوم بتحديث قيم جميع ال text box ما عدا ال drop down menu القائمة المنسدلة لا يتم تحديث قيمتها ولم اعلم سبب المشكله
هذا هو الكود
<?php
include('../include/connect.php');
error_reporting (E_ALL ^ E_NOTICE);
$id = intval($_GET['id']);
$emp_ssn = mysql_real_escape_string(htmlspecialchars($_POST['emp_ssn']));
$ar_name = mysql_real_escape_string(htmlspecialchars($_POST['ar_name']));
$en_name = mysql_real_escape_string(htmlspecialchars($_POST['en_name']));
$emp_state = mysql_real_escape_string(htmlspecialchars($_POST['emp_state']));
$emp_level = mysql_real_escape_string(htmlspecialchars($_POST['emp_level']));
$current_job = mysql_real_escape_string(htmlspecialchars($_POST['current_job']));
$work_before = mysql_real_escape_string(htmlspecialchars($_POST['work_before']));
$work_year = mysql_real_escape_string(htmlspecialchars($_POST['work_year']));
$work_place = mysql_real_escape_string(htmlspecialchars($_POST['work_place']));
if(isset($_POST['edit']) and $_POST['edit'] == 'news')
{
$update = mysql_query("UPDATE employee SET emp_ssn='$emp_ssn', ar_name='$ar_name' , en_name='$en_name' ,emp_state='$emp_state' ,
emp_level='$emp_level' , current_job='$current_job' , Work_before = '$work_before' ,
Work_year='$work_year' , Work_place='$work_place'
WHERE emp_ssn='$emp_ssn'")
or die(" not updated");
if(isset($update))
{
echo" update is done ";
}
}
$query = mysql_query("SELECT * FROM employee WHERE emp_ssn='".$id."'") or die("mysql ERROR");
$re = mysql_fetch_assoc($query);
if($_REQUEST['do']=='edit') {
echo "<form action='".$_SERVER['PHP_SELF']."' method='post'>
<table border='1' >
<tr>
<td colspan='2'><b><font color='Red'>Edit Records </font></b></td>
</tr>
<tr>
<td width='179'>
<b><font color='#663300'>Card Id</font></b></td>
<td><label>
<input type='text' name='emp_ssn' value='".$re['emp_ssn']."' />
</label></td>
</tr>
<tr>
<td width='179'><b><font color='#663300'>Arabic Name</font></b></td>
<td><label>
<input type='text' name='ar_name' value='".$re['ar_name']."' />
</label></td>
</tr>
<tr>
<td width='179'><b><font color='#663300'>English Name</font></b></td>
<td><label>
<input type='text' name='en_name' value='".$re['en_name']."' />
</label></td>
</tr>
<tr>
<td width='179'><b><font color='#663300'>State</font></b></td>
<td><label>
<input type='text' name='emp_state' value='".$re['emp_state']."' />
</label></td>
</tr>
<tr>
<td width='179'><b><font color='#663300'>Level</font></b></td>
<td><label>
<input type='text' name='emp_level' value='".$re['emp_level']."' />
</label></td>
</tr>
<tr>
<td width='179'><b><font color='#663300'>Current Job</font></b></td>
<td><label>
<input type='text' name='current_job' value='".$re['current_job']."' />
</label></td>
</tr>
<tr>
<td width='179'><b><font color='#663300'>Work Before</font></b></td>
<td><label>
<input type='text' name='work_before' value='".$re['Work_before']."' />
</label></td>
</tr>
<tr>
<td width='179'><b><font color='#663300'>Year of work</font></b></td>
<td><label>
<input type='text' name='work_year' value='".$re['Work_year']."' />
</label></td>
</tr>
<tr>
<td width='179'><b><font color='#663300'>Last work place</font></b></td>
<td><label>
<select size='1' name='Work_place' id='Work_place' tabindex='6' >
<option value='' selected>Please select job...</option>
<option value='".$re['WAITING AREA MANAGER']."'> WAITING AREA MANAGER</option>
<option value='".$re['ASSIT WAITING AREA MANAGER']."'> ASSIT WAITING AREA MANAGER</option>
<option value='".$re['SUPER WAITING AREA']."'> SUPER WAITING AREA</option>
<option value='".$re['STATION AGENT WAITING AREA']."'> STATION AGENT WAITING AREA</option>
<option value='".$re['ACCES WAITING AREA MANAGER']."'> ACCES WAITING AREA MANAGER</option>
<option value='".$re['ASSIT. ACCES WAITING AREA MANAGER']."'> ASSIT. ACCES WAITING AREA MANAGER</option>
<option value='".$re['SUPER ACCES WAITING AREA']."'> SUPER ACCES WAITING AREA</option>
<option value='".$re['STATION AGENT WAITING AREA']."'> STATION AGENT WAITING AREA</option>
<option value='".$re['TRAIN ATTINDDENT']."'> TRAIN ATTINDDENT</option>
<option value='".$re['مرشد تفويج']."'> مرشد تفويج</option>
<option value='".$re['STATION AGENT PLATFORM']."'> STATION AGENT PLATFORM</option>
<option value='".$re['STATION AGENT ROVING']."'> STATION AGENT ROVING</option>
<option value='".$re['STATION AGENT']."'> STATION AGENT</option>
<option value='".$re['PSD OPRITOR']."'> PSD OPRITOR</option>
</select>
</label></td>
</tr>
<tr align='Right'>
<td colspan='2'><label>
<input type='submit' name='submit' value='Edit Records'>
</label></td>
</tr>
</table>
<input type='hidden' name='id' value='".$id."'/>
<input type='hidden' name='edit' value='news'/>
</form>";
}
$data = mysql_query("select * from employee order by emp_ssn desc") or die(mysql_error());
echo "<table border='1' cellpadding='3'>";
echo "<tr>
<th><font color='Red'>Card Id</font></th>
<th><font color='Red'>Name</font></th>
<th><font color='Red'>State</font></th>
<th><font color='Red'>Level</font></th>
<th><font color='Red'>Current Job</font></th>
<th><font color='Red'>work brfore</font></th>
<th><font color='Red'>Year of work</font></th>
<th><font color='Red'>Last work place</font></th>
<th colspan=2><font color='Red'>Operation</th>
</tr>";
while($row = mysql_fetch_array($data))
{
echo "<tr>";
echo '<td><b><font color="#663300">' . $row['emp_ssn'] . '</font></b></td>';
echo '<td><b><font color="#663300">' . $row['ar_name'] .'<br>' . $row['en_name'] . '</font></b></td>';
echo '<td><b><font color="#663300">' . $row['emp_state'] . '</font></b></td>';
echo '<td><b><font color="#663300">' . $row['emp_level'] . '</font></b></td>';
echo '<td><b><font color="#663300">' . $row['current_job'] . '</font></b></td>';
echo '<td><b><font color="#663300">' . $row['Work_before'] . '</font></b></td>';
echo '<td><b><font color="#663300">' . $row['Work_year'] . '</font></b></td>';
echo '<td><b><font color="#663300">' . $row['Work_place'] . '</font></b></td>';
echo '<td><b><font color="#663300"><a href="ed.php?do=edit&id=' . $row['emp_ssn'] . '">Edit</a></font></b></td>';
echo '<td><b><font color="#663300"><a href="delete1.php?id=' . $row['emp_ssn'] . '">Delete</a></font></b></td>';
echo "</tr>";
}
echo "</table>";
?>ياليت اذا احد عرف الحل يساعدني ويقولي اين المشكله وكيف يتم تعديلها
شكرا جزيلا
