PHP - Sort Array By Year Gives Wrong Order

Hi guys,

I'm trying to sort an array. The array has information about listings. ID, name, info etc.

An unrelated set of data also contains the listing ID's and I have made a function to sort this array and show an new order for the ID's. I now need to sort the original array by this new ID order...

This snippet shows that the original listings array can be sorted by link_id:
sort($this->links, $this->link->link_id); //This works. It sorts links by link ID!

In a foeach loop I have created this:
$sleeps_array[] = array("ID" => $link->link_id, "Sleeps" => $sleeps); // Makes an array of arrays of a custom field with listing ID.

It makes this:
array ( 0 => array ( 'ID' => '9', 'Sleeps' => '2', ), 1 => array ( 'ID' => '3', 'Sleeps' => '4', ), 2 => array ( 'ID' => '6', 'Sleeps' => '6', ), )

I can then sort this array of arrays with this function:

function compare_sleeps($a, $b){
return strnatcmp($a['Sleeps'], $b['Sleeps']);
} # sort alphabetically by name
usort($sleeps_array, 'compare_sleeps');

It then gives me a sorted array according to "Sleeps" (as in, the number of people a property can cater for). It has the correct order of ID to then output but how do I organise the original array by ID with this new array?

Sounds complicated, I hope you got that!

Cheers, RJP1

Hello, not sure if lack of sleep or just staring at code too long.

This is what I have:

Code: [Select]
while($rowy = mysql_fetch_array( $resulty )) {
mpdate = YYYY-MM-DD
$date = $rowy['mpdate'];

$year = explode('-', $date);
$month = date("F", mktime(0, 0, 0, $year[1]));
?>

<?php echo $year[0]; ?>
<br>
<?php echo $month; ?>
<br>
<?php echo $rowy['mptitle']; 
}
?>

I figure if I use:

if ($year[0] == date('Y"){

echo month and entry stuff

}
 but I keep getting errors.

What I am trying to do is sort everything out into year month and day

ie:

2012
March
Entry 1
Entry 2
February
Entry 1
Entry 2
Entry 3
etc...

This is what I am getting

2012
March
Entry 1
2012
March
Entry 2
2012
February
Entry 1
etc...

Is there a way to fix this?

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 guys,  Having problems sorting mysql results. I can easily order/sort table columns but would like to order the results by a variable.(Distance in Miles).
Havent much experience in PHP and really struggling with this. Basically a query echoing out car make and models and how far they are located from a postcode. Can get it to work no porblem, but not to order/sort by least distance.

Heres what i'm working with:
Code: [Select]
$res=mysql_query("SELECT * FROM cars");
while ($row = mysql_fetch_assoc($res)){

echo $row['Make'];
echo $row['Model'];

//variable will be determimed by user input form
$postcode="W12 3SR";

$start=$postcode;
$ends = array();

//finds value from database field
{
$ends[]=$row['Location'];
}

// Postcode entered by user via input form
$result=mysql_query("SELECT * FROM postcodes WHERE Pcode='$start'");
while($row=mysql_fetch_array($result)){
$gridn[0]=$row['Grid_N'];
$gride[0]=$row['Grid_E'];
}

foreach($ends as $fin){
// Postcodes within mysql table
$result=mysql_query("SELECT * FROM postcodes WHERE Pcode='$fin'");
while($row=mysql_fetch_array($result)){
$gridn[1]=$row['Grid_N'];
$gride[1]=$row['Grid_E'];
}

// TAKE GRID REFS FROM EACH OTHER TO WORK OUT DISTANCE.
$distance_n=$gridn[0]-$gridn[1];
$distance_e=$gride[0]-$gride[1];

// CALCULATE THE DISTANCE BETWEEN THE TWO POSTCODES AND DIVIDE BY 1.6 TO CONVERT KM TO MILES
$hypot=sqrt(($distance_n*$distance_n)+($distance_e*$distance_e))/1.609;

//VARIABLE FOR DISTANCE AND ROUNDED OF TO NEAREST WHOLE NUMBER.
$distance=''.round($hypot/1000,0).'';


  echo " $distance miles";
  echo "<br>";
}
}
?>
I wish i could just do something like this but isnt possible, is it ?
Code: [Select]
"Select * FROM cars ORDER BY $distance";
Thanks!

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

}
        
?>