How do you sort php and sql arrays?

Question

How can I sort this array by city or by id in descending order?

if ($num > 0 ) {
$i=0;
while ($i < $num) {
$city = mysql_result($result,$i,"city");
$state = mysql_result($result,$i,"state");
$id = mysql_result($result,$i,"id");

echo "$city";
echo "$state";

++$i; } } else { echo "No results."; } ?>

Thanks, that worked great for sorting by id in descending order. How would I show only one city though? — Jon
– Jon, Commented Jun 3, 2010 at 2:53

Bug Magnet · Accepted Answer · 2010-06-03 02:52:05Z

4

You didn't include your SQL code in the above post, but that is the part of the code where you are supposed to add the ORDER BY sorting function as follows:

SELECT * FROM address_table ORDER BY city desc

answered Jun 3, 2010 at 2:52

Bug Magnet

2,6685 gold badges29 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jon Over a year ago

Thanks, you're right and it worked great for sorting by id in descending order. How would I show only one city though?

Matthew Flaschen Over a year ago

A WHERE clause. E.g. SELECT * FROM address_table where id = ? ORDER BY city desc

Bug Magnet Over a year ago

I am not sure what you mean... do you want to show all addresses that are from one particular city? (e.g. all addresses that are in the city of Beijing) If this is what you are trying to do, then use something like this: SELECT * FROM address_table where city = 'San Francisco' This will return a full list of addresses that are in the city of San Francisco. Is this what you meant by "one city"?

Stepan Suvorov · Accepted Answer · 2010-06-04 12:24:03Z

1

you can also use "LIMIT" for one city: SELECT * FROM address_table ORDER BY city desc LIMIT 0,1 - returns 1 row

answered Jun 4, 2010 at 12:24

Stepan Suvorov

26.3k27 gold badges117 silver badges178 bronze badges

Collectives™ on Stack Overflow

How do you sort php and sql arrays?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related