PHP - How Do I Sort The Info That People Put Into The Database, Getting Errors.

I have a standard form that displays users current data from a mysql database once logged in(code obtained from the internet). Users can then edit their data then submit it to page called editform.php that does the update. All works well except that the page does not display the updated info. Users have to first logout and login again to see the updated info. even refreshing the page does not show the new info. Please tell me where the problem is as i am new to php.   my form page test.php

<?PHP
require_once("./include/membersite_config.php");

if(!$fgmembersite->CheckLogin())
{
    $fgmembersite->RedirectToURL("login.php");
    exit;
}

?>
<form action="editform.php?id_user=<?= $fgmembersite->UserId() ?>" method="POST">
<input type="hidden" name="id_user" value="<?= $fgmembersite->UserId() ?>"><br>
Name:<br> <input type="text" name="name" size="40" value="<?= $fgmembersite->UserFullName() ?>"><br><br>
Email:<br> <input type="text" name="email" size="40" value="<?= $fgmembersite->UserEmail() ?>  "><br><br>
Address:<br> <input type="text" name="address" size="40" value="<?= $fgmembersite->UserAddress() ?>  "><br><br>

<button>Submit</button>

my editform.php

<?php

$con = mysqli_connect("localhost","root","user","pass");

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

mysqli_query($con,"UPDATE fgusers3 SET name = '".$_POST['name']."', email= '".$_POST['email']."', address= '".$_POST['address']."' WHERE id_user='".$_POST['id_user']."'");



header("Location: test.php");

?>

For some reason every time I run this form it inserts an undefined value into the field called sortorder into my database table. The rest of the form inputs insert properly but that one. Here's the necessary coding. Anyone see why?


form page

<?php
   
// Include the database page
require ('../inc/dbconfig.php');

?>

<script type="text/javascript">
    $(document).ready(function() {
    $('div.message-error').hide();
    $('div.message-success').hide();
     $("input.submit").click(function() {
             $('div.message-error').hide();
            var charactername = $("input#charactername").val();
        if (charactername == "") {
             $("div.message-error").show();
             $("input#charactername").focus();
             return false;
           } 
           var charactershortname = $("input#charactershortname").val();
        if (charactershortname == "") {
             $("div.message-error").show();
             $("input#charactershortname").focus();
             return false;
           } 
           var sortorder = $("input#sortorder").val();
        if (sortorder == "") {
             $("div.message-error").show();
             $("input#sortorder").focus();
             return false;
           } 
            var style = $("select#style").val();
        if (style == "") {
             $("div.message-error").show();
             $("select#style").focus();
             return false;
           } 
            var status = $("select#status").val();
        if (status == "") {
             $("div.message-error").show();
             $("select#status").focus();
             return false;
           } 
            var alignment = $("select#alignment").val();
        if (alignment == "") {
             $("div.message-error").show();
             $("select#alignment").focus();
             return false;
           } 
           var division = $("select#division").val();
        if (division == "") {
             $("div.message-error").show();
             $("select#division").focus();
             return false;
           } 
             var dataString = 'charactername=' + charactername + '&charactershortname=' + charactershortname + '&sortorder=' + sortorder + '&style=' + style + '&status=' + status + '&alignment=' + alignment + '&division=' + division + '&submitcharacter=True';
             $.ajax({
             type: "POST",
             url: "processes/character.php",
             data: dataString,
             
              success: function() {
              $('div.message-error').hide();
                $("div.message-success").html("<h6>Operation successful</h6><p>Character " + charactername + " saved successfully.</p>");
                $("div.message-success").show().delay(10000).hide("slow");
                $(':input','#characterform')
                .not(':submit')
                .val('')
                return true;
            }
              
       });
       return false;    
         });
  });
  
</script>

<!-- Form -->
<form action="#" id="characterform" >
<fieldset>
<legend>Add New Character</legend>

<div class="field required">
<label for="charactername">Character Name</label>
<input type="text" class="text" name="charactername" id="charactername" title="Character Name"/>
<span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
</div>
        <div class="field required">
<label for="charactershortname">Character Short Name</label>
<input type="text" class="text" name="charactershortname" id="charactershortname" title="Character Short Name"/>
<span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
</div>
        <div class="field required">
<label for="sortorder">Sort Order</label>
            <select class="dropdown" name="sortorder" id="sortorder" title="Sort Order">
            <option value="0">- Select -</option>
            <?php
                $sortorder = array("A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","0-9");
                foreach($sortorder as $so):
            ?>        
            <option value="<?php echo $so; ?>"><?php echo $so; ?></option>
         
         <?php endforeach; ?>
            </select>
<span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
</div>
        <div class="field required">
<label for="style">Character Style</label>
            <select class="dropdown" name="style" id="style" title="Style">
            <option value="0">- Select -</option>
            <?php
            $query = 'SELECT id, stylename FROM styles LIMIT 2';
            $result = mysqli_query ( $dbc, $query ); // Run The Query
            while ( $row = mysqli_fetch_array ( $result, MYSQL_ASSOC ) ) { 
                print "<option value=\"".$row['id']."\">".$row['stylename']."</option>\r";
            }
            ?>
            </select>
<span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
</div>
        <div class="field required">
<label for="status">Character Status</label>
            <select class="dropdown" name="status" id="status" title="Status">
            <option value="0">- Select -</option>
            <?php
            $query = 'SELECT id, statusname FROM statuses';
            $result = mysqli_query ( $dbc, $query ); // Run The Query
            while ( $row = mysqli_fetch_array ( $result, MYSQL_ASSOC ) ) { 
                print "<option value=\"".$row['id']."\">".$row['statusname']."</option>\r";
            }
            ?>
            </select>
<span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
</div>
        <div class="field required">
<label for="alignment">Alignment</label>
            <select class="dropdown" name="alignment" id="alignment" title="Alignment">
            <option value="0">- Select -</option>
            <?php
            $query = 'SELECT id, alignmentname FROM alignments';
            $result = mysqli_query ( $dbc, $query ); // Run The Query
            while ( $row = mysqli_fetch_array ( $result, MYSQL_ASSOC ) ) { 
                print "<option value=\"".$row['id']."\">".$row['alignmentname']."</option>\r";
            }
            ?>
            </select>
<span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
</div>
        <div class="field required">
<label for="division">Division</label>
            <select class="dropdown" name="division" id="division" title="Division">
            <option value="0">- Select -</option>
            <?php
            $query = 'SELECT id, divisionname FROM divisions';
            $result = mysqli_query ( $dbc, $query ); // Run The Query
            while ( $row = mysqli_fetch_array ( $result, MYSQL_ASSOC ) ) { 
                print "<option value=\"".$row['id']."\">".$row['divisionname']."</option>\r";
            }
            ?>
            </select>
<span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>
</div>
         <input type="submit" class="submit" name="submitcharacter" id="submitcharacter" title="Submit Character" value="Submit Character"/>
</fieldset>
</form>
<!-- /Form -->

<!-- Messages -->
<div class="message message-error">
    <h6>Required field missing</h6>
    <p>Please fill in all required fields. </p>
</div>

<div class="message message-success">
    <h6>Operation succesful</h6>
    <p>Character was added to the database.</p>
</div>
<!-- /Messages -->



validation page

<?php

// Include the database page
require ('../inc/dbconfig.php');

if (isset($_POST['submitcharacter'])) {
    $charactername = mysqli_real_escape_string($dbc, $_POST['charactername']);
    $charactershortname = mysqli_real_escape_string($dbc, $_POST['charactershortname']);
    $sortorder = mysqli_real_escape_string($dbc, $_POST['sortorder']);
    $style = mysqli_real_escape_string($dbc, $_POST['style']);
    $status = mysqli_real_escape_string($dbc, $_POST['status']);
    $alignment = mysqli_real_escape_string($dbc, $_POST['alignment']);
    $division = mysqli_real_escape_string($dbc, $_POST['division']);

    $query = "INSERT INTO `characters` (charactername, charactershortname, status_id, style_id, division_id, alignment_id, sortorder, creator_id, datecreated) VALUES ('$charactername','$charactershortname','$status','$style','$division', '$alignment', '$sortorder', 1, NOW())";
    mysqli_query($dbc, $query) ;

}
        
?>

Hey guys, I am having trouble figuring this out. I currently have a database that automatically sorts itself by the id of the data. But, I am wanting the user to be able to change the sort order via a select box. I already have the select box programmed with the options, but I am not sure how to go about coding the options to change the sort order of the displayed data. What would the best way to go about programming this be?

Thank you very much ahead of time!!

I'm currently trying...struggling....to teach myself PHP and I'm really bugged with this database stuff. I am slowly managing but I'm a tad bit stuck now.

I want to show a specific piece of information from a table.

Lets say my table is structured like so:

id user email 1
Bob
Bob@Name.com
2 Fred Fred@Name.com 3 Matt Matt@Name.com
What would I need to do to display ONLY Freds user?

One way I tried only displayed the first rows info (Bob) the second way I tried (with a while loop) only displayed the last rows info (Matt)

Heres my current code:
<html>
<body>
<?php
include 'dbwire.php'; 

$query = mysql_query('SELECT * FROM user');

$row = mysql_fetch_array($query); 

while ($row = mysql_fetch_array($query)) { 
echo '<b>User:</b> ' . $row['user'] . '<br />';
}
?>
</body>
</html>

Hello all,

I have a directory page that is populated with a foreach loop pulling info from a db table. I want to make a "Download Directory pdf" button that will print out the directory entries in a nicely formatted way.
 The thing is that the foreach loop uses an OO call to what every template is being used for the HTML display:

foreach ( (array) $results as $row)
{
     ...

$out .= '<div class="cn-list-row' . $alternate . ' vcard ' . $template->slug . ' ' . $entry->getCategoryClass(TRUE) . '">' . "\n";

$out = apply_filters('cn_entry_before', $out, $entry);

ob_start();

include($template->file);

    $out .= ob_get_contents();

    ob_end_clean();

$out = apply_filters('cn_entry_after', $out, $entry);

$out .= '</div>' . "\n";

}

$out .= '<div class="clear"></div>' . "\n";

$out .= '</div>' . "\n";

$out = apply_filters('cn_list_after', $out, $results);

return $out;
}

Any Ideas??