PHP :: Sorting Data

Data Sorting
I have a database table that has these fields: id (auto increment), date, message and what I wanted to do is sort the messages in order starting from the latest messages. I then wanted to sort the messages and only show 5 messages per page. I managed to do all this but now I also want all the messages with the SAME DATE (but different times) to be shown in the same table. for example: Code:

Sorting Data Help
I know this should be fairly easy, but I am still very new at this. Ok, I am trying to pull data from my database and sort it. I want it to sort it by using field one sorting alphabetically, but only pulling up results from field two that has a specific name. I am not explaining this well sorry. I'll give you the code that I am trying and it's not working because I know I am not doing it right.

$result = mysql_query("select * from items where itemName Like'A%' and WHERE field2='value' order by itemName asc");

Sorting Data
I want my web site to be as dynamic as possible (hence the reason for trying to master php) but the knowledge I have at the moment will not quite stretch to doing the following:

I want to have the height attribute of an image to be controlled by data in a database table. The table will hold the numeric test result that pupils score when they take a test on my web based tutorial. The image is a column, the larger the score, the larger the column. I would like to know: Code:

Sorting Data
i'm creating a page that has pagination. but the data just gets listed on and on . is it possible for a 5 data to go across in a single row, then break, and another 5 data across again, like in this image: Code:

Sorting / Splitting Data
I have some member data in a field in a MySQL table that I want to work with in PHP and output to HTML. Let's say the data in one cell of a table looks something like this:

Joe Smith:user@aol.com
Nancy Beck
Greg Jones
Sarah Lister:sarahb@yahoo.com

Now, I know that I can use 'explode' and the character together to put each of those values in an array in PHP so I have something to loop and be able to output the names in a list. But I still have the ":" delimiter within those results, and I want to be able to link the email addresses to their respective names as I run the loop. Is there an easy way in PHP to do this?

Sorting Data - Whats The Best Way?
I have a number of members stored in my database, and i would like to create a page to allow people to browse through the members and see certian bits of information.

I would like this page to be dynamically ordered (sorted) by the date the information was last updated, thereby keeping the most up to date information at the front, and penalising those that dont update often.

I am thinking of simply adding a field in my database, and inserting a gregorian timestamp (based on the servers current date) everytime a member updates the info.

Firstly, is this the best way of keeping track of updates ?

And, how would i go about ordering my data by this particular data?..... does php have an "order by" function?

Sorting Display Data
Here's the situation:

On our Golf Leaderboard, when scores are submitted, the actual numerical scores are to be sorted from lowest numeric value to the highest, while the 'over/under par' values are sorted from highest to lowest. This works just fine when only TWO scores are submitted, and displayed.

Anything over 3 player scores, it reverses the sorting of the data stated above.

Here's the PHP file: (I consider this script 'short' - I hope it falls with the parameters mentioned by the staff) Code:

Paginating And Data Sorting With Php/mySQL
I have a main menu full of information which is paginated 20 records per page. I'm trying to make the query so that the user can sort the data by links located at the top of the page.

"What's My Problem?" - It works, when I select the link it sorts by whatever I have selected as I want but...

The Problem - It only sorts one page and doesn't continue on, when I click page two the values are reset. This is a new operation to me so if anyone could offer a suggestion I'd appreciate it.

The Question - How do I sort paginated data and make it so the data stays sorted throughout the 20 or so pages?

Sorting Multiple XML Data By Date
I am making an RSS parser that takes multiple XML inputs in to an
array and then sorts them by their date value... and it 'almost'
works... I always lose the top value of the second rss feed to be
parsed... its pretty annoying as this is often the most recently
updated RSS item that is missing from my multi-feed...

usort($xmlreader_parsed_data, "rss_cmp");

which calls this function:

function rss_cmp($a, $b)
{
$a = strtotime($a->date);
$b = strtotime($b->date);

if ($a == $b) {
return 0;
}
return ($a $b) ? -1 : 1;
}

Data Field With Currency Not Sorting Accurately
I have a datatable with a varchar field know as "price". At this time I have 3 rows in it; they are as follows: $ 18,500 $19,500 and $ 9,500. The problem is that when I try to sort in either ascending or descending order; it does not sort right. I know the problem lies in the $ 9,500, because I added a zero in front of the 9,500 (like this: $ 09,500) and it sorted fine. At first I thought it may have had something to do with the dollar sign, but it didn't because I removed and tested it without dollar sign and still had the same problem.

What I want to know is, how I can make datatable sort accurately with putting a zero in front of the 9,500. I tried to use a CSS style to cover up the zero, but when I did that, datatable still would not sort the right way. MySQL code in my web page is accurate, because you can take the $ 9,500 and add a 5 digit number and it works fine.

Sorting...
I was trying to sort a multi-dimensional array with one dimension being the sorting criteria. I wanted to make it sort by an alternative one if the main one is equal on two entries.

However that doesn't work: it sorts properly according to the main criteria, but it won't sort according to the alternative one. I hope you understood what I'm trying to say, since I'm not a native English speaker. Here is my code:

Sorting By Word?
Okay, I am making a member database, and when I print it out I want it to display the list by rank. Unfortantly, I stored Rank as a word. I could make a sort function that would be quite extensive and probably take a long time to execute every time...

..Or, is there anyway I can specify in SQL: Put this on the top of the list if "rank='General'" and then next if "rank='Captain'", and so on? I think if this was possible it would take a lot less time to execute...

Or else I will probably have to redesign much of the site with numerical ranks instead. Thanks for any answers/advice.

Sorting Options
I have an array I would like to sort, but the sorting options that I have found are inadiquate. I need to do a case insensitive sort, that does not maintain the index correlation. My problem is I have some items in my array beginning with "a" and some with "A", and I want the sorting based strictly on the letter not the case, and then I have to be able to reference them in an order that maintains the sort.

Sorting Strings!
Hi

I need to read a .txt file and sort the value, highest firs, lowest last.

The .txt file contains the following info on a different row:
altavista:joe:5
yahoo:eric:2
disney:dis:4

the firs thing i did was reading the first line and split the code by ":" so that
echo $referrer[0] //would give altavista
echo $referrer[1] //would give joe
echo $referrer[2] //would give 5

I want to sort these lines on the numbers(highest first, lowest last) and print this in a table. How can i do this?
so what i would like in a table is this

<table>
<tr><td>
altavista</td><td>5</td></tr>
<tr><td>
disney</td><td>4</td></tr>
<tr><td>
yahoo</td><td>3</td></tr>
</table>

Is this possible anyway?

Sorting An Array
I'm trying to sort a listing of albums alphabetically for LyricsList.com, the problem is that I want the initial 'The' and 'A' in some albums (A Hard Days Night, The Wall) to be ignored. So that the list will look like:

Abbey Road
Dark Side Of the Moon
The Final Cut
A Hard Days Night
Kill 'em All
The Wall

ABC order, 'A' and 'The' negated. The info comes from a database, in three calls:

// call albums that begin with letter $letter
$query = "SELECT * FROM albums WHERE album LIKE '$letter%' ORDER BY album";
$result = mysql_query($query) or die(mysql_error());

// call albums that begin with letter A
$query_a = "SELECT * FROM albums WHERE album LIKE 'a' ORDER BY album";
$result_a = mysql_query($query_a) or die(mysql_error());

// call albums that begin with letter T
$query_t = "SELECT * FROM albums WHERE album LIKE 't' ORDER BY album";
$result_t = mysql_query($query_t) or die(mysql_error());

So I need to get just the albums from $result_t that begin with 'The ' (easy regex) and from $result_a that begin with 'A ' (easy regex), but puting the three of them in order is proving beyond my skill.

Thanks in advance for any advise.

Sorting Algorithm In Php
the sort() function in php, what kind of sorting algorithm is it? selection sort? bubble sort? insertion sort? if i were to create my own sort, which would be fastest for sorting many string values?

Number Sorting
I have a database from which I extract the top ten rows, dependent on a certain value. However, when two entrys have the same value they get the same placement in the "top ten" thingie. I know I can sort them first by position, then by for example name, but that doesn't do it for me.

(1) Printing the values gets me;

1. Malmö
2. Limhamn
3. Jönköping
4. Stockholm
4. Västerås
5. Sjöbo
5. Södertälje
6. Väsby
6. Ystad
6. Örebro

(2) The problem is that it SHOULD say;

1. Malmö
2. Limhamn
3. Jönköping
4. Stockholm
4. Västerås
6. Sjöbo
6. Södertälje
8. Väsby
8. Ystad
8. Örebro

You see the difference? In (1) "5. Sjöbo" should actually be "6. Sjöbo", since it's the sixth value, cause there are two cities sharing the number 4 spot.

The code I'm using;
Code:
while($row = mysql_fetch_object($result)) {
if ($prev_value == $row->name) $i=$i-1;
echo $i.". ".$row->city_name."
";
$prev_value = $row->name;
$i++;
}

Sorting By Number
What I am looking for is a way to sort either a few variables or an array.

i.e I have an array
$myarray[1] = 12
$myarray[2] = 76
$myarray[3] = 3
$myarray[4] = 27
$myarray[5] = 52

Now I want to be able to sort the array by the value of it, so it would come out as.

52
76
27
12
3
Anyideas how to do this?

Order Sorting
I have been trying to search a script on how to start making a Order Sorting on field or items on db. Do not know on how to start it.. It's already making me nuts.. I have this excel format that i want to converted on php to be accessible on a webpage. that act like an excel.

something like with a item look up on a database with a specific criteria.

Item Search [text box]
Old [button]
New [button]
Hot realease [button]

........

Array Sorting
i have to retrieve some info from tables and then add all the fields together, then list out. 10 records per time, then got 2nd page, 3rd page..so on...

my problem is ..i can't get my records to sort(highest point to lowest point), then i decided to use array. PHP Code:

Sorting Csv File
I'm trying to sort a csv file on a specific field, but am having
trouble figuring out where to start. Any ideas?

Sorting Problem
I want to make categories on a website, like folders that have a tree to
them...

I was wondering if the best way is to have it in an array and have them all
point to each other and sort them with some sort of algorithm.

Is this the best way to do it?

Sorting Numbers
I'm trying to sorting a file in a directory.
It works well but it sorts me the number in this way:

1
10
11
2
20
21
....

is there a way to sort in this way?
1
2
3
...
10
11
12

this is my code:

<?php
if ($handle = opendir('/home/davide/')) {
$files = array();
while (false !== ($file = readdir($handle))) {
if (($file != "." && $file != "..") AND (eregi($select,$file)))
$files[] = $file;
}
closedir($handle);
sort($files);
foreach($files as $file) {
$ext = substr(strrchr($file, "."), 1);
if ($ext == 'txt') {
$idx = str_replace('.txt', '', $file);
echo "$idx";
}
}
}
}
?>

Sorting Information
I have a script that completes a mysql query and displays all the information & all works fine

The problem im having is that i only want it to display the information i tell it too ie...

there are 3 people with an age of 40 and the rest with various other ages, can someone point me in the right direction to get the script to display only those who are 40 & ignore the rest...

Sorting An Array
I have a performed a fairly simple calculation on a mysql table which has returned a new set of values the only problem I have is that I want to sort them using this new value.
PHP Code:

Sorting Array?
I have an array that has 3 keys and I want to sort the array by the values in the key called "key3" so which sort function do I use? array("key1"=>"hey", "key2"=>"hello", "key3"=>"hi")

Sorting XML Results
The following code parses an XML file and displays the results. The function resultSort is meant to sort the results by price from highest to lowest. Unfortunately, it's not sorting correctly in all cases. I think this may be due to the prices being in euros. Right now, this is how it outputs the results:

1 208,00
2 148,00
412,00
638,00
942,00

This is how it should look:

2 148,00
1 208,00
942,00
638,00
412,00

Here's the code: PHP Code:

Not Alpha Sorting!
A couple of quick questions! Does this count as one query, as I have managed to reduce my queries from 13 to 1? PHP Code:

Sorting Variables
I have built a database of basketball statistics. I am only storing the most NECESSARY information. Example, I am not storing "points scored" because points scored = (field goals made * 2) + three-pointers made + free throws made.

After doing a select query to get all of the data from the table, I create a variable called $ppg for points per game [((field goals made * 2) + three-pointers made + free throws made) / games]. I use "( $row = mysql_fetch_array($result))" and "extract($row);" to put the data into variables. The problem is I can't figure out how to sort by a variable.

In order to make my top 10 scorers list, I have to "cheat" by ordering by "((field goals made * 2) + three-pointers made + free throws made) / games" in my sql query. I want to be able to order the data by the variable $ppg. Code:

Sorting Results
I hava a table with a primary key cod_topico and I'd sort my results.
I do this, ok?
$query='SELECT * from topico order by cod_topico asc' ;
But I would not sorting asc, How I sort a non-asc form? What is the oposite of asc?

Listing/sorting
I want to print out only if the site is in the database. this works for the links,
however, if the there is no site under that letter I still have the output of the letter.
if I do it under the second example I have a letter for each link. How can I do this? Code:

Need Help Sorting A XML File
I have a similar xml file and I redisplay it with the following array in
PHP. What I would like to do is sort the <idfield before it is
redisplayed. Looking for a sample code.

<rss>
<item>
<id>3</id>
<name>Brian</name>
</item>
<item>
<id>1</id>
<name>James</name>
</item>
<item>
<id>5</id>
<name>Mark</name>
</item>
<item>
<id>2</id>
<name>Keith</name>
</item>
<item>
<id>4</id>
<name>Derek</name>
</item>
</rss>
.............

Query Sorting
How would I have a query return only the top 3 or so entries based on a certain fields highest value? example,

entry 1 = 32
entry 2 = 21
entry 3 = 18
entry 4 = 41
entry 5 = 39
entry 6 = 22
entry 7 = 36

I would only want entries 4,5 and 7 to be returned. The top three out of the seven entries.

Sorting Files
i have a small little problem - i am looking for some sort of script, that will allow me to sort out files into order, determined by their filename, eg. 30-04-2005.php - would be a file that has todays date - i use dates for filenames, as events happen on these days, and its easier to find them.

Files are currently automatically sorted after being created, into a folder, and subfolder, depending on what the filename date is, for example, 30-04-2005.php would go in the folder ./2005/04/ - whereas 05-06-2004.php would go in ./2004/06/.

The sorter I am looking for, will sort all the files that lie in the folder, into order, after they have been created, onto a list where each link goes to the particular file, preferably, with the name of the month at the top of the monthly list, the files that belong into the month, in date order (ie. 1st april, would be above 10th april) - and the list contains all the months for the year, in month order (ie. jan-dec), and the file with the list in, lies in the year folder, so it can be accessed easily.

One more small thing - for the current year, the files are all in reverse order, so that the latest file is at the top - but again, sorted into months, but going down from dec-jan....

Dat And Time Sorting
I'm trying to program a small news system... I have DATE and TIME separated and they are in DATE and TIME format, not varchar or anything. How can I sort this news the way that the very top of the news is the last news posted. Cos if I put a SORT BY newsdate, newstime DESC. or by

SORT BY newsdate DESC I only get an order by day but the last news is at the bottom. Also... how can I change with DATE_FORMAT the format of my DATE cos I have it in YYYY-MM-DD format and I've tried many ways to change it to DD-MM-YYYY but I can't find the way out.

Sorting Doesn't Sort?
I've got an array of arrays that I need to sort on preferably one of the
indices of the nested array, keeping the order of the outside array. The
structure is like this:

array([i] => array(key["name"] => data)
and what I need to do is to sort the nested array alphabetically according
to key["name"].
I can either use the name property of the nested array as index for the
outside array (then I need to keep the relationship between the outside
array and the nested array, or use a numeric index thus making the
relationship between the outside and nested array irrellevant.) What I need
to do in any case is to sort the nested array. I've tried using
arsort($array, SORT_STRING) but for some reason this doesn't sort the array
the way that I expected.

A var_dump of one element of the outside array looks like this:
array(2)
{ [1]=> array(2)
{ ["id"]=> string(1) "1" ["name"]=> string(6) "JustforShow" }
{ [2]=> array(2)
{ ["id"]=> string(1) "1" ["name"]=> string(6) "Testing" }

etc.

Sorting Folders
I have a site with photo-albums on it.
Each directory represents an album.
What i want is on the "home page" of the site a feature
which says "newest album: *******"

So i have to search the album directory, and then sort them
by date. And then it automatically has to grab the newest album.

Maybe a slight problem is that the albums are divided over 4
subcategories. (Match, players etc.)

Match: - Match 1
- Match 2
- Match 3

Players: - player 1
etc...

Albums would be 'Match 1', 'Match 2', etc.

hope ypu understand.

Sorting Arrays
having some trouble understanding what is happening with some array
sorting functions. In all cases, my compare function is:
function compare($x, $y)
{
if ( $x[1] == $y[1] )
return 0;
else if ( $x[1] < $y[1] )
return -1;
else
return 1;
}
I started with this:
$contents = array( array( 'TIR', 'Tires', 100 ),
array( 'OIL', 'Oil', 10 ),
array( 'SPK', 'Spark Plugs', 4 ) );
echo '<br>XXX<br>'
foreach($contents as $r) {
var_export($r);
echo '<br>'
}
echo '<br>YYY<br>'
uasort($contents, 'compare');
foreach($contents as $r) {
var_export($r);
echo '<br>'
}
And the output, whether I use usort or uasort is always:
XXX
array ( 0 => 'TIR', 1 => 'Tires', 2 => 100, )
array ( 0 => 'OIL', 1 => 'Oil', 2 => 10, )
array ( 0 => 'SPK', 1 => 'Spark Plugs', 2 => 4, )

YYY
array ( 0 => 'OIL', 1 => 'Oil', 2 => 10, )
array ( 0 => 'SPK', 1 => 'Spark Plugs', 2 => 4, )
array ( 0 => 'TIR', 1 => 'Tires', 2 => 100, )
But if I use uksort I get:
XXX
array ( 0 => 'TIR', 1 => 'Tires', 2 => 100, )
array ( 0 => 'OIL', 1 => 'Oil', 2 => 10, )
array ( 0 => 'SPK', 1 => 'Spark Plugs', 2 => 4, )

YYY
array ( 0 => 'SPK', 1 => 'Spark Plugs', 2 => 4, )
array ( 0 => 'OIL', 1 => 'Oil', 2 => 10, )
array ( 0 => 'TIR', 1 => 'Tires', 2 => 100, )

But I cannot see why I get this reversal of order???

I then tried:
$contents = array( array( c=>'TIR', d=>'Tires', p=>100 ),
array( c=>'OIL', d=>'Oil', p=>10 ),
array( c=>'SPK', d=>'Spark Plugs', p=>4 ) );

MySQL Sorting
I'd like to do is divide results from a MySQL query over multiple pages, each holding a certain number of results. Now I have a PHP script that uses the MySQL command LIMIT in the query to get # results at a time (which also means not all the results are returned every time, just a few, obviously this is a good thing for speed/load so I wanna keep it that way).

The MySQL manual states that if you use LIMIT # with ORDER BY, MySQL will end the sorting as soon as it has found the first # lines Ok I could've posted this on the MySQL forum first but actually I was wondering whether someone has a solution in PHP for this?

Sorting Results
What I need to do is from the query I send sort the results by ID numbers from highest to lowest, because the highest number is the most recent news post I would like this to be printed first and then the lower the ID number the further down the post goes. Am I making sense? PHP Code:

Sorting A 3d Array
I am trying to sort the display url subarray and it works, however, the other arrays stay in there place which throws the whole thing off. How do I sort by displayurl and make the other sub arrays move with it? PHP Code:

Sorting Dates
i have a db full of events and i need to display the next event on a page. is there any way i can sort the dates after i have got them from the db or do i need to sort them in the sql query and how would i do it?

Sorting By Date
im trying to sort a fixtures list by date! But obviously it just sorts it by first numbers for example it orders the list by day value and not day and month, i found this code in a previous post :

SELECT DATE_FORMAT(date_field, '%W %M %Y')FROM table_name

Trouble is i dont really understand. How do i implement that if i want to select all from the table and order it by the date???

Sorting An Array
im going to loop through 17 thousand mysql entries (each entry has aunique, and incremental, id) then calculate a rating of each entry based on some other information. (between 1 and 5). I then want to sort the data with the highest rated entries at the top of the list?

my first plan was to add each calculation into an array, as the array...

How Can I Tell Which Way My Database Is Sorting?
Ive got some mysql results,.. and I have wrote a simple script to sort them by column headers. Little link and url var to tell the sql which way to sort. My problem is how to I go about assigning ASC or DESC? Now that seemed real simple to me,. but then the question came up. How is it sorted in the first place?

If I could find out how it is sorted then it would be fairly simple to do an if statement to change the var in the ORDER BY clause. Anyone know how to tell which way the results are sorted to begin with?