Before I start, I am also having problems with FLUSH PRIVLAGES. It never has worked, so I skipped "or die" on it so I could just move on. Any help on this would be great. Now with my current problem, here is my code:

$query = "UPDATE sigs_acidalia SET (sigprice,sigwidth,sigheight,ipofadder) = ('$sigprice','$sigwidth','$sigheight','$ipofadder') WHERE sigid='$sigid')";
						mysql_query($query) or die(mysql_error());

(and right after that, the flushing🙂

$query = "FLUSH PRIVILEGES";
						mysql_query($query) or die('Your Insertion was <b>Sucessfull.</b><br>But your Flush Privlages was denied.<br>Click <a href="subm1t_acidalia.php">HERE</a> to add another.');

and the error I get is:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(sigprice,sigwidth,sigheight,ipofadder) = ('$200,000','550','250','') WHERE sigi' at line 1

    $query = "UPDATE sigs_acidalia SET 
sigprice = '$sigprice',
sigwidth = '$sigwidth',
sigheight = '$sigheight',
ipofadder = '$ipofadder' 
WHERE sigid = '$sigid'";

      Well, that worked, but why? Isn't it just the same exact thing?
      ANd you dont perhaps know anything about the Flush Privlages do you?

        EDIT::

        Well I did "or die" on Flush Privileges, and the error I got was:

        Access denied; you need the RELOAD privilege for this operation

        And I've been looking on Google, and people get this error for many different things, not only Flush Privileges. But everywhere I read, there was no way to resolve the issue. Guess it's not that common? :xbones:

          Well it means exactly what it says: you do NOT have the RELOAD privilege. Either use a user account that does, or grant the RELOAD privilege to the account you are using.

            Okay, how do I go about Granting the Reload Privlage to my account? If it is granting it to the whole database, then I think that I may not have the ability to do that, it would be my webhost's decision. And I think if they wanted people to have it, they would already have it enabled.

            So does this mean I can not ever Flush privlages? What is the importance of flushing privlages?

              Pooptart wrote:

              What is the importance of flushing privlages?

              Well if you don't know then why are you wanting to do it?

              All that flush/reload does is to reload the settings from the privileges table which in the process will remove any runtime changes that have been made. Not something usually needed by the average script.

                I was trying to do it because it is in every tutorial ive read. I thought maybe it was of importance.

                  Write a Reply...