RE: Help with Updating database from PHP? 07-27-2016, 09:34 PM
#12
Then it might be that the mysql account you are using to query changes to the database does not have the UPDATE privilege, Try running the query in PHPMyAdmin, then see if the change gets applied there, it might be the permission problem
EDIT: I see your order field is an INT,
Try this line:
I hope you noticed, I made a mistake in my previous query that I provided for the bind_param, I accidentally added SELECT_ORDER twice and SELECT_GAMERTAG got neglected. I think that might be why it's not updating:
EDIT: I see your order field is an INT,
Try this line:
Code:
$stmt->bind_param("ssds", $_POST['select_rank'], $_POST['select_tag'], $_POST['select_order'], $_POST['select_gamertag']);I hope you noticed, I made a mistake in my previous query that I provided for the bind_param, I accidentally added SELECT_ORDER twice and SELECT_GAMERTAG got neglected. I think that might be why it's not updating:
Code:
$stmt->bind_param("ssss", $_POST['select_rank'], $_POST['select_tag'], $_POST['select_order'], $_POST['select_gamertag']);
(This post was last modified: 07-27-2016, 09:41 PM by Ex094.)



![[+]](https://sinister.li/images/modern/collapse_collapsed.png)