Thread: php redirect stops sql

hey guys, for some weird reason the SQL command isn't updating the table, but if I put an echo after the query so it stops the header from running it updates any ideas??

nothing wrong with the SQL query as if i add echo "." just before the header redirect it updates the table

PHP Code:

    if ($_POST['action'] == 'accept'){
        ## accepting the terms
        if ($_POST['accepted'] == "1"){
            sqlconnect();
            ## accepted the terms update the database and the session
            $query = "UPDATE admin_users SET terms = '1' WHERE userid = ".quote_smart($_SESSION['admin_userid']);
            $sql = mysql_query($query) or sqlerrorhandler("(".mysql_errno().") ".mysql_error(), $query, $_SERVER['PHP_SELF'], __LINE__);
//            echo $query;
//            echo ".";
            $_SESSION['admin_terms'] = '1';
            if ($sql){ 
                header("Location: ".ADMINURL."adminFrame.php");
            }
            
//            $redirect = "true";
        }
    } 


doing my head in now

Did you figure it out yet?

kind of, rewrote it several times each time it was doing something different, eventuall figured out i was using a !== on the session to check it instead of != lol stupid php bits

Well, what is your output buffering set to?

If you have your output buffering to release it as it loads, then that's most likely your culprit.