Update is not working
<p>Please Help.When I run this code, there is no update in my database;</p>

<pre><code>mysql_query("UPDATE users SET 

Fname=$first_name,

MI=$mi,Surname=$surname,Gender=$gender,Age=$age,

Address=$address,Password=$password,Bdate=$theDate,

Occupation=$occupation,Email=$emailadd,Class=$class 

where ID_Number='$ID_Number'");

if($query)

{

echo '&lt;script&gt;';

echo 'alert("Updating account Complete")';

echo '&lt;/script&gt;';

header('location:main.php?page=search');

}

else

{

echo '&lt;script&gt;';

echo 'alert("Updating account failed")';

echo '&lt;/script&gt;';

}
</code></pre>
