I connect to MySql to return property values <?= $Home["id"] ?>

How can I get it to display in reverse order.

Any Ideas?

Thanks

In your query put
ORDER BY DESC

ASC = Ascending
DESC = Descending

Interesting this isn't working.

I added ORDER BY Id DESC. It changes the order in phpMyAdmin but it didn't change it on the site. ??

<?
$connection = mysql_connect($Host, $UserName, $PassWord);
mysql_select_db($DataBase);
if($lang == "f")
   $Select = "Select homes.id, type_f as type, short_description_f as short_description, description_f as description, " . 
             "location_f as location, address_f as address, rented, sold " . 
             "from homes, market where homes.id = market.home_id and rented = 1";
else
   $Select = "Select homes.id, type_e as type, short_description_e as short_description, description_e as description, " . 
             "location_e as location, address_e as address, rented, sold " . 
             "from homes, market where homes.id = market.home_id and rented = 1";
$Homes = mysql_query($Select);
?>

And

  <?
$Counter = 0;
while($Home = mysql_fetch_assoc($Homes)) {
?>

Maybe it's in this code somewhere?


Or maybe I need to add multiple columns?

SELECT "column_name"
FROM "table_name"
[WHERE "condition"]
ORDER BY "column_name" [ASC, DESC]

Sorry for the noob question

You need to add it in the php query, not phpMyAdmin.

Needs to be something like this:

$Select = "Select homes.id, type_f as type, short_description_f as short_description, description_f as description, " .
"location_f as location, address_f as address, rented, sold " .
"from homes, market where homes.id = market.home_id and rented = 1 ORDER BY id DESC";

Beautiful !! Thank You very much.

I need to get up to speed with SQL for sure...

No problem. Hopefully that will work for you.

You can use simple query like

select name from table order by name desc

thanks