Update Query issue in PHP

Question

$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.";

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

s-sharma · Accepted Answer · 2009-10-11 19:21:19Z

1

Your code seem to be fine, Have u checked whether $levDes have some values or not before query. echo the query or $levDes.

answered Oct 11, 2009 at 19:21

s-sharma

2,0451 gold badge16 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kevin Over a year ago

Thanks i missed it in Flex... while dispatching

Collectives™ on Stack Overflow

Update Query issue in PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related