MySQL查询需要额外的页面刷新才能显示UPDATE更改

Question

Why does this not show the changes after submit? The page has to be refreshed AFTER submission to see the changes.

$full_path = 'users/'.$_SESSION['user_id'].'/images/'.$name;

if($query = mysql_query("UPDATE user_info
                         SET user_image = '$full_path'
                         WHERE user_id = '".$_SESSION['user_id']."' AND
                         username = '".$_GET['username']."'
                         "))
                        {

    if(move_uploaded_file($tmp_name, '/Applications/XAMPP/xamppfiles/htdocs/'.$full_path)) {
        echo 'Got it!';
        }

    }

So, if I upload / click submit, the query is successful, but you can't see the changes until an additional page refresh.

Answer 1

Make sure that your update query is before your select for your data in the execution of the PHP page.