5 replies to this topic

[bbqroast]

mysql_query("UPDATE `user_data` SET `ID` = $ID, `IGN` = $IGN, `joindate` = DEFAULT, `rank` = $rank, `username` = $username, `password` = $password, `email` = $email, `flag` = $flag WHERE `ID` = $userID") or die(mysql_error());

that rather long piece of code is *meant* to update my database with some new details.

Instead I just get redirected (which it only does if the query is ran), but then promptly sent back to my update page asking me to reenter the details.

You see when flag is 0 you get sent to the update page to enter new details, the details then get processed (I have checked all this) before getting updated into the DB.

Looks like this query is going unheeded??

[WingedPanther]

Without seeing the surrounding code, it's really hard to know what's going on. Have you verified what statement is being run and that it actually results in an update? I've found that running tests with a SQL tool before and after these types of statements helps a lot, as does outputing the SQL to run as a diagnostic.

[bbqroast]

How do you recommend??
I do retrieve some data from the same table and that works fine.
I'll try to find the MySQL logs.

[WingedPanther]

[COLOR=#000000][COLOR=#0000BB]echo [/COLOR][COLOR=#007700][/COLOR][COLOR=#DD0000]"UPDATE `user_data` SET `ID` = $ID, `IGN` = $IGN, `joindate` = DEFAULT, `rank` = $rank, `username` = $username, `password` = $password, `email` = $email, `flag` = $flag WHERE `ID` = $userID"[/COLOR][COLOR=#007700][/COLOR][COLOR=#0000BB][/COLOR][COLOR=#007700];  [/COLOR][/COLOR]

I'm fond of using SQuirreL SQL client, though PHPMyAdmin cna work, too. Just looking at the above, I note that you haven't delimited most of the values I would expect to be strings, for example.

[bbqroast]

Deliminated?? Oh, you mean surround with `s or 's?

[WingedPanther]

I would expect the following to be more likely:

[COLOR=#000000][COLOR=#0000BB]echo [/COLOR][COLOR=#DD0000]"UPDATE `user_data` SET `ID` = $ID, `IGN` = $IGN, `joindate` = DEFAULT, `rank` = $rank, `username` = '$username', `password` = '$password', `email` = '$email', `flag` = $flag WHERE `ID` = '$userID'"[/COLOR][COLOR=#007700]; [/COLOR][/COLOR]