[mudrig]

Oh jeez, I think we got it. You forgot to add the Value attribute to the OPTION tags hence it's returning gamer_tag null I think

Replace this line:

Code:

echo "<option>" . $row['user_name'] . "</option>";

With this:

Code:

echo "<option value='" . $row['user_name'] .  "'>" . $row['user_name'] . "</option>";

Also just in case to make sure inputs are coming correctly, Echo out all the POST variables like:

Code:

echo $gamertag;
echo $rank;
echo $tag;
echo $order;

Okay so it is doing it correctly by pulling in the values

Its outputting like tis

New records created successfully test Recruit [DSxR] 27

but it is still not updating it in the database

[Ex094]

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']);

[mudrig]

Ive never ran a query threw PHPMyAdmin . How could I run a statement with out having the form and all in it?

[Ex094]

Ive never ran a query threw PHPMyAdmin . How could I run a statement with out having the form and all in it?

First try out what I just said in the EDIT on my previous post, might as well work

[mudrig]

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']);

Ive never ran a query threw PHPMyAdmin . How could I run a statement with out having the form and all in it?

First try out what I just said in the EDIT on my previous post, might as well work

Okay I changed it to that and now im getting this
No data supplied for parameters in prepared statement test Recruit [DSxP] 26

[Ex094]

Okay I changed it to that and now im getting this
No data supplied for parameters in prepared statement test Recruit [DSxP] 26

Did you try both?

[mudrig]

Okay I changed it to that and now im getting this
No data supplied for parameters in prepared statement test Recruit [DSxP] 26

Did you try both?

Yes I tried both and got the same thing on each.

---

its almost like no data is being supplied to this now

Code:

$stmt = $conn->prepare("UPDATE users SET user_rank =?, user_tag =?, list_order =? WHERE user_name = '$gamertag'");

[Ex094]

Here's the complete shebang, run this:

HTML:

Code:

<form method='post' action='user_rank_change.php'>

<!-- Gamertag Select -->
<h3 for='select_gamertag' >Select GamerTag</h3>
<select class="form-control" id='select_gamertag' type='text' name='select_gamertag'>
<?
while($row = mysqli_fetch_array($result6))
{
echo "<option value='" . $row['user_name'] .  "'>" . $row['user_name'] . "</option>";
}
?>
</select>

<!-- Select Rank -->
<h3 for='select_rank' >Type rank as it is shown below</h3>
<input id='select_rank' type='text' name='select_rank' class="form-control" placeholder="Example: Recruit">

<!-- Select Tag -->
<h3 for='select_tag' >Type tag as it is shown below</h3>
<input id='select_tag' type='text' name='select_tag' class="form-control" placeholder="Example: [DSxR]">

<!-- Select Order -->
<h3 for='select_order' >Type order as it is shown below</h3>
<input id='select_order' type='text' name='select_order' class="form-control" placeholder="Example: 27">

<!-- Submit Form -->
<button type="submit" class="btn btn-default">Change Rank</button>

</form>

PHP:

Code:

// set parameters
$gamertag = $_POST['select_gamertag'];
$rank = $_POST['select_rank'];
$tag = $_POST['select_tag'];
$order = $_POST['select_order'];

//Check if all params recieved
echo $rank . " " . $tag . " " . $order . " " . $gamertag;

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
   die("Connection failed: " . $conn->connect_error);
}

// prepare and bind
$stmt = $conn->prepare("UPDATE users SET user_rank =?, user_tag =?, list_order =? WHERE user_name =?");
$stmt->bind_param("ssss", $rank, $tag, $order, $gamertag);
if(!$stmt->execute()) {
    echo $stmt->error;
} else {
   echo "New records created successfully";
}

$stmt->close();
$conn->close();
?>

If this doesn't work, I can help you over team viewer later. need to get some shut eye

[mudrig]

Alright thanks for all the help I'll try this when I get home and let you know how it goes.

[mudrig]

That worked. Looks like I just had the parameters backwards on that.

Now one more question since you have been so helpful. How would I make this form after submitted go back to same page and Display above form the result from the action of the form submit.