Update Query issue in PHP
<pre><code>$id=mysql_real_escape_string($levelid);
     $l=mysql_real_escape_string($level);
     $levDes=mysql_real_escape_string($leveldescription );
     $sql="UPDATE `levels` SET level='$l',leveldescription='$levDes' WHERE id='$id' LIMIT 1";
     $result=mysql_query($sql);
     if(!$result){throw new Exception(mysql_error());}
     $effectedRows=mysql_affected_rows();
     if(!$effectedRows){
      $sql="SELECT * FROM `levels` WHERE level='$l' AND id='$id' LIMIT 1";
      $result=mysql_query($sql);
      if(!$result){throw new Exception(mysql_error());}
      if(mysql_num_rows($result)==0){
       throw new Exception("Could not find Level's record in database to update.");
      }else{//no changes to the row 
       return "Level successfully updated in database although no changes were detected.";
      }//else
     }//if
     return "Level successfully updated in database.";
</code></pre>

<ol>
<li>When i try to update, the level gets updated but not the leveldescription. </li>
<li>Also level is unique, but it does not throw error when i enter duplicate value.. though the DB is not getting affected.</li>
</ol>
