# PHP not updating mysql

**URL:** <https://forum.kirupa.com/t/php-not-updating-mysql/276407>\
**Category:** programming\
**Created:** [November 26, 2008, 8:45pm UTC](https://forum.kirupa.com/t/php-not-updating-mysql/276407 "2008-11-26T20:45:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![revin](https://avatars.discourse-cdn.com/v4/letter/r/919ad9/32.png) [@revin](https://forum.kirupa.com/u/revin)\
**Post date:** [November 26, 2008, 8:45pm UTC](https://forum.kirupa.com/t/php-not-updating-mysql/276407/1 "2008-11-26T20:45:02Z")

</div>

```php
################################################################################
#------------------------------------------------------------------------------#
# Activate Function
#------------------------------------------------------------------------------#
################################################################################
function Activate(){
DBconn();
            $result = mysql_query("SELECT userid FROM users WHERE code=".$_GET["code"]);
             $row=mysql_fetch_row($result);
             $ID=$row['userid'];
             if(mysql_numrows($result) != 0){
                   $query = mysql_query("UPDATE users SET isactive='1',code='0' WHERE userid='$ID'");
                   echo 'Your account is now active, feel free to login now'.$row['userid'];
             }else{
                   echo _VALIDATE_ERROR;
             }
       
}

```

i’m not sure what i’m doing wrong, its supposed to check and see if theres a matching code in the database and update it if it does find a matching code

but so far does not can someone help please?