Having a problem running a query

[Hall of Famer]

umm the mysql update query wont work? Well I've had problems like this at times but theres really an easy way to debug. The mysql query string may have a typo in it, or the variables used to locate or update the database contain wrong information. To debug, lets consider the example below:

PHP Code:

runquery("UPDATE {$prefix}adoptables_conditions SET promocode='{$code}' WHERE type='{$type}'"); 


The query string is enclosed in the function runquery. The variable $code is used to update database info, while the other variable $type is used to locate the specific row in a table. You can debug by outputting values inside the variables $code and $type to the screen and see if they contain the correct information. If so, you've apparently made a typo with the query string. Otherwise, chances are you've incorrectly assigned values to $code or $type.

[!Alive]

PHP Code:

$number=rand(1,2);
    if ($number == 2){
    runquery("UPDATE ".$GLOBALS['prefix']."users SET explore='1' WHERE username".$GLOBALS['loggedinname']);
    
    $query = "SELECT * FROM ".$GLOBALS['prefix']."users WHERE username".$GLOBALS['loggedinname'];
    $result = mysql_query($query);
    $explore=@mysql_result($result,0,"explore");
    echo "$explore";

    return $explore;
    if ($explore == 1){
    header( 'Location: browseprize.php' ) ;
        }
        } 


That's my code I'm running. I don't think I have any sytax errors, but I'm still new to this so I could be wrong.