PHP - Order/sort Mysql Results

Hi guys,

I have this SQL query which I use in my PHP search script Code: [Select]
$query_for_result=mysql_query("SELECT * FROM customer WHERE c_name like '%".$query."%' OR c_telephone like '%".$query."%' OR c_address like '%".$query."%'");
It works fine, the only problem is now my database is bigger I would like to be able do SORT or ORDER BY id so that my search results are in order from asc to desc.

Is this possible? if so can you help me.

Thanks

Hi All

i am wanting a column list like this

http://extensions.joomla.org/extensions

basically the database is set up as
(id, category, parent)

I want the parent to group the category section and list like the the joomla example in three columns

search various threads throughout the internet but none seem to cover this entirely

can any one please help?????

What im trying to achieve is a user contact system, when the user types input in the textarea its saved in a database along with his userid on the site and the date, I have an admin side coded up where it retrieves the data, but there is no order. I want to have it display the most recent results on top. I have looked into this in the mysql manual, but you know how that is its so hard to make sense of anything in that damn manual.

Im using a while loop to display the data. How can I achieve this?

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

}
        
?>

Hi,

I have a loop which creates an array:

$productions[] = array( 'url'=>get_the_permalink(), 'year'=>$production_year->name, 'title'=>get_the_title() );

When I output the results, the year is in the wrong order:

2019
2018
2017
2016
2015
2014
2020

What I can't work out is how to order 2014 - 2020

I tried ksort(array, SORT_STRING) and ksort(array, SORT_NUMERIC)

I also tried natsort 

But still have the same issue - am I missing something?

Thanks