Login Register






Help with Updating database from PHP? filter_list
Author
Message
RE: Help with Updating database from PHP? #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:
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.)
My Blog: http://www.procurity.wordpress.com
Donations: 1HLjiSbnWMpeQU46eUVCrYdbkrtduX7snG

Reply





Messages In This Thread
Help with Updating database from PHP? - by mudrig - 07-27-2016, 07:50 PM
RE: Help with Updating database from PHP? - by Ex094 - 07-27-2016, 09:34 PM