PHP :: Sort The Data

Sort Data Problem
Hi, I got a problem. I want to sort mysql select results in a way that is not handeled by mysql itself. I was said that what I want might be possible to solve via php, but I have no clue how. Every help appriceated... The problem:

say I got a table "test" with columns "Row" and "Text". For example
Row | Text
---------------------------------------------------
1 | blablabla <order>2</order> blabla
2 | hladdbla <order>1</order> haaabla
3 | alablabla <order>3</order> dblabla
Now what I need is to sort this table by the numbers inside the <order> tags. The result should be: row 2, 1, 3

As I said, unfortunately this cant be done in mysql - I tried this:
SELECT * FROM `test` ORDER BY text='<order>%</order>'
with no result.

View Replies ! View Related

Best Method To Sort Data Using Php
This is a two part question: First, what is the best method to sort data using php. When info is uploaded a sort field is given where the user enters 0 or 1 or so on... Code:

View Replies ! View Related

Sort Data By Field
how coding to sort data by field..i try my codinhg but filed.. Code:

View Replies ! View Related

Sort The Data Normally And Descending Order?
Im displaying data from a mysql query that displays a Player, email, id etc.. and I have links that sort the data by player, email, id etc... But Ive seen websites where you click sort and it will sort the data by that and if you click it again it will sort that data this time in descending order.

How am I able to have link that will sort the data normally and descending order?

View Replies ! View Related

Sort The Array Before Outputting The Data
I do a SQL query and normally just do a "while ($data = mysql_fetch_array($sql))" and echo the output. What I want to do now is to sort the array before outputting the data, to get it in the correct order.

I cannot just sort the data in the SQL query as I have to sort a column containing data in the format of "Firstname1 Lastname1 and Firstname2 Lastname2" and the sorting for that column has to be sorted by Lastname1 ASC. I figure this is somehow done using a sort array command but I am very lost on how to do achieve this sorting.

View Replies ! View Related

Echo Data From Table By Sort
I have a data table that holds all of the sites users submit, and I have a small query that sorts them by rating:

$ratingQuery = mysql_query("SELECT * from news ORDER BY Rating");

while($ratingRow = mysql_fetch_array($ratingQuery)) {
//Here is code to show the stuff
}

However, I am not sure how to get specific data for the top 15 rows in the table. Say I wanted to get data from the columns "URL, Title, User, Rating".

However, I need them to be different for each of the 15 rows, because I am getting the top 15 highest rating stories and then echoing the data from them onto the page. I was thinking of using an Array, but I am not sure how to go about doing that?

View Replies ! View Related

Best Way To Add A Sort Option For The Entered Data
Example: I have a books table in my database that has an auto incrementing id field, and a name field. I sort them by name automatically when posting to the browser.

What is the best way to add a sort option for the entered data in the backend to be able to sort the books by moving them up or down?

So I would be able to control what book would show first, second, third, and so on, in the list of books shown to the public for viewing.

I have seen this feature in Mambo where you have the choice to re-number the items for sort order, and they typically have the up and down arrows that you can click as well.

Would I just add another field called sort_order and store a number in that box? Or is there a better/easier way to do it?

View Replies ! View Related

Sort Data In Table By Column
What I am trying to do is setup a page that lists items in the database and the table headers are links that sort the table by that column.

For example, on the page books.php I have this table:

Book Name | Book Author | Book Release Date | Book Genre

By default the results from the table 'books' are sorted by Book Release Date (book_release_date) DESC.

When someone clicks on 'Book Name' at the top of the table I'd like for it to reload the page with the SAME results sorted by the book name. If my query is:

$query = "SELECT * FROM books WHERE book_active=1 ORDER BY book_release_date DESC";

How do I get it to reload the page and read a different query? Can I have multiple queries on each page? If so, how does the PHP/mySQL know which one should be used when.

View Replies ! View Related

Array_multisort - How To Create A New Array For Data And Sort It.
I have some code that retrieves a list of dealers. I need to sort thsi list on a field that doesn't exist in the tables.

Distance from customer will be the field (I have a function for this). I can calculate this but once I get the distance how do I resort the list in ascending order by distance.

The code below displays all the dealers but not the closest one first. It is pretty random. Like I said I know how to calculate the distance but don't know how to create a new array for this data and sort it.

Here is some pseudo code that I am using ...

View Replies ! View Related

Sort Data By Region And The Alphabetical Order
I try to sort my data by region and the alphabetical order for each page the code is okay this way PHP Code:

$query = 'SELECT * FROM artist WHERE LEFT(english_name, 1) = "'.$_GET['letter'].'" ORDER BY english_name ASC'

but when i add region = '.us.' into the query, i have problem display, and it gives me this error message Unknown column 'a' in 'where clause'

$query = "SELECT * FROM artist WHERE region = '.us.' AND LEFT(english_name, 1) = ".$_GET['letter']."";

How can i fix the problem?

View Replies ! View Related

PHP Script To Sort Data/create Pages According To Fields?
Someone fills out 3 fields. (There will be more but this is just to
give you an idea)

1. Country
2. State
3. City

I want this script to generate a web page and list the people by
information submitted.

eg. Everyone that put in USA will be listed on a page.

or

Choose California and everyone that typed in California will be listed
on a page.

I can also create links with criteria at the end. eg.
mysite/search.php?=montana

This script will also accept data from people. So people will visit,
type of the form and if the information is valid (not spam) then
they'll be in a database and able to be sorted.

View Replies ! View Related

Looking For A PHP Script To Sort Data/create Pages According To Fields.
eg.

Someone fills out 3 fields. (There will be more but this is just to
give you an idea)

1. Country?
2. State?
3. City

I want this script to generate a web page and list the people by
information submitted.

eg. Everyone that put in USA will be listed on a page.

or

Choose California and everyone that typed in California will be listed
on a page.

I could also create a link with the search term at the end. eg.
mysite/phpsearch=?montana

This script will also accept data from people. So people will visit,
type on the form and if the information is valid (not spam) then
they'll be in a database and able to be sorted.

View Replies ! View Related

Create A Hidden Field Which Contains Some Sort Of Unquie Data
I have a page with a form, and I handle it in the same page. I submit some text and it is displayed. The problem is I want it to be displayed just after I click submit. I'm trying to put a header(link to same page) after the user submit, but it is not working. I can only view the message when I submit, and manually refresh the page on the browser menubar.

View Replies ! View Related

Using PHP To Sort Data In MySQL Table 1 By Values In Table 2
I have a MySQL database with 2 tables in it. products and prices.. Products has a field in it called 'prodno'. Prices has a field in it called 'prodid'.

There is one of each item in products and each product has it's own unique 'prodno'

There are multiple instances of each product's pricing in prices.. One for each price.. So if a product had multiple prices depending on quantity it would have an entry for each price.. Example:

id = 1
prodid = 7001
qty = 300
price = 12.5

id = 2
prodid = 7001
qty = 400
price = 15.5

I was wondering if I could query the database getting info from the products table but sort it according to the prices in the prices table.

Kinda like doing a "SELECT * FROM products" ordering it by the lowest price value from each item..

This is all very confusing to me, and I'm the one writing it. Let's try one last time..

Query the database selecting * from products (I plan on using all the info in products) and ordering them by the lowest price for each item in the prices table. I've tried sorting the results of just a basic SELECT * FROM products using Javascript and PHP but with pagination in the results it makes it a bit hard.

View Replies ! View Related

How To Sort By IP
I have a db field to store IP addresses. I want to be able to sort them so they appear in numerical order. But when I do the "ORDER BY ip" it sorts only by the first number of the entire IP address, so a 125.x.x.x would be before an 88.x.x.x ip. Is there a way around this so that it puts them in total correct order?

View Replies ! View Related

Best Way To Sort
i got a table with all the names in mysql, and i have use pear's DB to get all the names out. i want to sort all the names start with A in array_a, names start with B in array_b, ETC. i just wondering what is the best way to sort my problem. N.B don't want to use 26 sql to get all the names. or using 25 if statement to seperate them.

View Replies ! View Related

With Sort By
The query below is quite self explaining, selecting the last 30 people online and order by last_online. SELECT name, level FROM table ORDER BY last_online DESC LIMIT 30;
The colomn 'level' can consist of three values 0, 1 and 2. How can I modify the query so it selects 10 rows from each 'level' = 30 rows, still ordered by last_online ?

View Replies ! View Related

Sort()
I have 3 workshop choices as select boxes on a form -- like Workshop A, Workshop B, Workshop C. The drop down box for each workshop has 3 options: "First choice", "Second choice", "Third choice". The user is supposed to rank order his/her preference for workshops. I'm trying to figure out how to take the input and then output a string that says something like:

Your first choice is: Workshop C
Your second choice is: Workshop A
Your third choice is: Workshop B

I know that I need to collect the values in an array and then use sort(), but I can't wrap my mind around how to do it. Here's how I have each select box coded right now, but if there's a better way, that's cool. I have a hunch I'm missing a conceptual piece so I may need to start from scratch: Code:

View Replies ! View Related

Sort By SUM Value?
Why can't I order by SUM value? I get this error "Invalid use of group function".

$sql="SELECT *, SUM(sm), SUM(gm), SUM(a), SUM(tp), SUM(um)
FROM spelarstat
WHERE lagid = '".$_GET['id']."'
GROUP BY spelarid
ORDER BY SUM(tp) DESC, SUM(gm) DESC, SUM(a) DESC, SUM(um)";

View Replies ! View Related

Sort
I have a problem with sort. I have to calculate in a table how many times an
individual user appears; I also have to show 3 users who appear the most.

View Replies ! View Related

Sort By
I'm having some problem thinking of a way to sort my tables by their respective fields when clicked on. At the moment I have my code set up as so: Code:

echo ' <tr>
<th>ID</th>
<th>Name</th>
<th>Director</th>
<th>Actors</th>
<th>Release Date</th>
<th>Plot</th>
<th><a href="my_test.php?sortby=rating"> Rating</a></th>
</tr>'

The only problem with that was, when the Rating header was clicked, It displayed the sorted Fields at the bottom of the already displayed 'SELECT * FROM moviedb' Table, duplicating the data.

View Replies ! View Related

Two Tables To Sort
I have two tables. Table 1 has the following columns: id, number and headline. Table 2: id, number, description.

What I need to do is sort the rows from both tables to one page sorted by the field "number".

I had two solutions:
1. Two queries from which I create one array. The array can then be sorted with PHP's function. The problem with this is that a "number" can have the same value in both tables.
2. Creating a temporary mysql table, inserting the data there and then selecting it ordered by the number. The problem with this one is concurrent users. If the table exists already and another user starts shoving "his data" to the table it all gets messed up.

View Replies ! View Related

Array Sort By Value
I have an array that has the following structure:

Array
(
[0] => xml_make Object
(
[name] => Alfa Romeo
[totalItems] => 270
)

[1] => xml_make Object
(
[name] => Aston Martin
[totalItems] => 7
)

[2] => xml_make Object
(
[name] => Audi
[totalItems] => 948
)

[3] => xml_make Object
(
[name] => Austin
[totalItems] => 51
)

[4] => xml_make Object
(
[name] => BMW
[totalItems] => 2235
)
}

How can I sort the array by the value in total Items?

View Replies ! View Related

A Question Of SORT
I've been looking into a minor little glitch in one my programs. I'm writing a transaction table for sales orders, and two of the fields are 'Number of Distrbutions' and 'Sales Order Distribution'. The Number of Distributions contains the total number of line items for an order, the Sales order Distribution is the number associated with any given line item.

You can probably already guess the problem I'm having with this. When I read the sales order out of the database, it will be read out of order, ie,

1
10
11
12
2
20
21
3
4
5

I understand using natsort will resolve this problem. But the problem lies in the database, not in the actual sorting. In other words, I'm not reading these lines from an array where I might apply natsort. So my question would be, how do I sort this out (pun intended) with the database (MySQL).

The first solution I've come up with is to make my field (SOD) a text field, default ?', and superimpose the line item number. That should work... and would be easier than trying to populate an array and re-sort everything.

Is this the sort of thing (another pun intended) you've dealt with, and what was your solution?

View Replies ! View Related

Sort By Rank
I want is to figure out a rank by whoever has the most unique pageviews would be number one and the least would be last.

View Replies ! View Related

Sort-Problem
with the code below the output is sort by $verantw but $title and
$file in the same row DON'T belong to $verantw.

How do I have to make the sort command that $verantw, $title and $file
in the row "belongs together"?

Hope you understand my problem......

<?php
$handle = opendir('.');
$daten = array();
$daten['files'] = array();
$daten['title_tags'] = array();
$daten['verantw'] = array();

while ($file = readdir($handle)) {
if (substr($file, -4) == '.htm') {
$daten['files'][] = $file;
$html = file_get_contents('./' . $file);
preg_match_all('/!!!!(.*)!!!!/', $html, $matches);
if (isset($matches[1][0])) {
$daten['verantw'][] = $matches[1][0];
}
preg_match_all('!<title>([^<]+)</title>!i', $html, $matches);
if (isset($matches[1][0])) {
$daten['title_tags'][] = $matches[1][0];
}
}
}

sort($daten['verantw']);

$nr = 0;
$max = count($daten['verantw']);
for ($i = 0; $i < $max; $i++) {
echo "<tr>";
echo "<td class="text" width="4%">".++$nr."</td>";

echo "<td class="text" width="28%"><a class="link"
href="".$daten['files'][$i].""
target="_blank">".$daten['files'][$i]."</a></td>";

echo "<td class="verantw" width="25%">";
if ($daten['verantw'][$i]) echo $daten['verantw'][$i];
else echo ' '
echo "</td>";

echo "<td class="text" width="35%">";
if ($daten['title_tags'][$i]) echo $daten['title_tags'][$i];
else echo ' '
echo "</td>";
......
?>

View Replies ! View Related

I Need To Sort An Array
Current Case:
I have a table in a database

PRODUCTS
--------------
product_id
product_name
product_category
product_order

I am trying to create a change order script. With Up/Down links.

So I run my querry and store the data in the database. So I end up with an
array ....

View Replies ! View Related

How To Sort A Non-asc Form?
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?

View Replies ! View Related

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.

View Replies ! View Related

Arra_merge Sort
array_merge( $List, array( 'current' => 'Current' ) ); Is there anyway I can sort "current" to be the first for output?

View Replies ! View Related

How Do You Sort Records?
I have a db table "person" that I can sort by title, first_name,
last_name, or city with no problems at all because "title",
"first_name", "last_name", and "city" are columns in the table.

The requirement is to ALSO sort by department NAME. Problem is, I
can't do that in the "person" table because the column is
"department_id" which is a foreign key constraint to the department
table.

How do I sort the person records by department_name based on this?

I am using PHP 4.3.2 and MySQL 4.0.10

Now, second problem and even more of a problem:

The requirement is to ALSO sort by state NAME and country NAME. The
fields "state" and "country" in the "person" table contain only an
abbreviation of state and country; the corresponding full name of each
state and country are found in respective XML files in /xml/state.xml
and /xml/country.xml

View Replies ! View Related

PHP MYSQL Sort
My website setup is PHP Version 4.4.1, MYSQL 4.1.11. When the database results are returned and displayed they seems to ignore the sort/ order by clause. At times the order seems to be in reverese or exactly as the results are in the database.

I also noticed that the problem arises after an update to the MYSQL database but that doesn't explain why the order by in PHP is ignored.

View Replies ! View Related

Joins Of A Sort
I have two tables.

1. with a list of airports, and their codes.
2. with a list of flights, with flight data and airport codes.

I have a query which is working fine in gathering all the flight information from table 2. Now, when i post the data in a table, i want to show the name of the airport, however, in table 2, it doesn't contain the name of the airport, only the airport code.

I want to get the airport name from table 1, while still maintaining the error free query that i have mentioned above.

I've tried the Select `table1`.*, `table2`.* from `table1`, `table2` where Working query AND `table1`.airportcode = `table2`.aircode order by what-ever.

and try to post the data from table 2, but i get no results where as before i got some.

View Replies ! View Related

RSS Array Sort
I am pulling in a few RSS feeds into my site and I need to be able to sort the array I build by the pubdate of the feeds. The resulting array looks like this:

Array
(
[0] => Array
(
[title] => Title of Feed
[link] => link of feed
[pubdate] => 2007-05-04 00:00:00
[description] => Description
)

[1] => Array
(
[title] => Title of Feed
[link] => link of feed
[pubdate] => 2007-06-04 00:00:00
[description] => Description
)

I need to be able to sort by $theitems[$i]['pubdate'], how can I do that?

View Replies ! View Related

SORT / While / Query
I am trying to sort a query by the state_name column for viewing. I have a table where I SELECT a city and state_id for a user. Once I have the city and state_id I am able to SELECT characteristics (including the state_name) relevant to each city and state from another table (the data has to be in a separate table). I want to display the data in rows that are sorted, but also have the cooresponding city and state listed with the characteristics.

Because I am taking data from two different tables, and running a 'while loop' for one query dependent on the other, the ORDER BY function does not work (at least that is what I think is the problem). The data IS being displayed with the appropriate fields associated, but I cannot sort the way I want. I have included code:

View Replies ! View Related

Partial Sort
if I have an array of ten items how can I sort the first five items in the array without sorting the second five items?

View Replies ! View Related

Having Problems With Sort();
I'm having trouble with sort(); I can't seem to get it to work... Now, I just typed this up... Just psedocode, although it *might* actually work! lol! Do I have the right idea? I haven't had any luck getting sort to do anything yet... Do I need to create a multidimensional array or something? Code:

View Replies ! View Related

Sort By Relevance
I have three tables: companies, categories and a linking table where each company is linked to up to five categories. I want to create a page that shows, for any particular comapny, the other companies listed in order of how similar they are in choice of category.

So if one company has internet and computers linked to it, a second has internet and design and a third has design and print, the first has one match to the second but no matches to the third so the second would rank above the third in that companies page. I'm sure it's possible to do this using a single SQL query but cannot work out how.

View Replies ! View Related

Sort Issue In IE6
$lookup=mysql("$DBName","SELECT * FROM events ORDER BY EvDate ASC");

For some reason the sort is not working when I load the page in IE6 or Opera.

How can a browser have any effect on a PHP query? This is done server-side, correct? I have changed the sort to DESC and it works great again in Firefox. No change in IE6, etc. I mix up the query and it always pulls the right data, but only sorts right in FireFox.

View Replies ! View Related

Sort By Date Rather Than Name
The script below outputs mp3 files from a directory and sorts the output by name. I would like it to sort the output by date rather then by name. I have a variable $datec in my script that checks when the mp3 files are created. Code:

View Replies ! View Related

Sort By Alphabetically?
I have table with list of users. They can list either their real name or their fake names. If they provide fake names I must use those, if not -- use real. Fields are like this: PHP Code:

firstName_real
lastName_real
firstName_fake
lastName_fake

Is it possible to sort them alphabetically? I wrote a logic where if fake name used it is used in the name string: PHP Code:

if ($fakename != '')
{
$fname = $fakename;
} else {
$fname = $realname;
}

// ect...

View Replies ! View Related

Sort An Array
How do we sort 3 dimensional array by sorting on 3 , 2 and 1st dimensions?

View Replies ! View Related

Round() Sort Of!
I am looking for more rounding variations Here is what I need implementing:

if ends by .25 or <.25 the result will end by .00

if ends by > .25 or <.75 the result will end by .50

if ends by >.75 the result will end by .00 + 1

I may write a function but I am afraid that on a busy site it could impact on performance
Any suggestions?

View Replies ! View Related

Timestamp Sort
i have a system that captures registrations. the registrations are timestamped. the default sort when i view the entire table is by name. how can i sort by the latest registration at the top? i've tried to do ORDER BY [timestamp] DESC.

View Replies ! View Related

Sort Results By Id
i have a page that show the results of a query on a member database up untill today its been in order of ID but thats all changed how can i force it to sort the results by id e.g 001 002 003 etc.

View Replies ! View Related

Date Sort
In the snipett of code below I added ORDER BY `Date` and was able to get the list sorted however I need the last article written to show first in the list....

View Replies ! View Related

Sort Table By # And A-z
I have a table that I would like sorted by the user. The table headings need to be links. When the user clicks on WO# for example it needs to sort numerically.

When the user clicks on User it needs to sort alphabetically. Here is the code that I have already. The table headings are what need to be links and those are outside of the php tags. I really need help on this one this page is due today! Code:

View Replies ! View Related

Sort Results
I have a query that is producing a list. Code:

$specific_value = 'Industrial'
$query = "SELECT * FROM table_links WHERE cat = '" . mysql_real_escape_string($specific_value) . "'";
$result = mysql_query($query);

if(!$result) die("ERROR: " . mysql_error());

while($row = mysql_fetch_array($result)) {
echo '<a href="'.$row['mfr_url'].'">'.$row['manufacturer'].'</a><br>'

I would like to sort it alphabetically. How would I include that in my query?

View Replies ! View Related

Sort An Array By Sub Key
If i have this array : PHP Code:

(
    [0] => Array
        (
            [id] => 9
            [date] => 2005
        )

    [1] => Array
        (
            [id] => 10
             [date] => 2002
        )

    [2] => Array
        (
            [id] => 11
            [date] => 2004
        )

)

Is there any function to sort it by date key ?

View Replies ! View Related

Sort Foreach XML
I'm trying to sort the foreach code below but using sort() doesn't work, using the code below how do I sort a xml file from the bottom up and not the top bottom? Code:

View Replies ! View Related

Sort By Categories
two tables: category and product. top level category has the parent_id as 0, and subcategory's parent_id is its parent category's category_id.

table: category

name
category_id
parent_id
sort_order

table: product

name
product_id
category_id
sort_order

I only have two level categories. Now I want to list all my products, sort by top level (parent_id is 0) category's sort order first, then sort by subcategory's sort order (parent_id is not 0), then sort by product's sort order. This is a general category-subcategory-product database. Someone must already have an efficient sql written. Could you share it with me?

View Replies ! View Related

Sort The Data

one of my partners send me an example (design) how to he wonts to sort the data from mysql, look at picture (Untitled-1.jpg). I try it, and I can't find the way how to do this. Code: