help with tweaking code

[emeraldcat]

Hi!

I'm totally useless with PHP, but I've inherited this website and need some help with it.

Right now, I have this little form:

http://www.beautifuldreamhomes.com/admin/addtour.php

which adds a new tour to this page:

http://www.beautifuldreamhomes.com/virtualtours/index.php?page=1

However, it adds the newest posts to the END of the list. So the newest homes appear on page 19.

I need the newest posts to appear at the beginning of the list - on page one. I also want to switch the order of the ones that are up there now, although I suppose I could do that manually.

Can anyone help me with this? :bemused:

Thanks!

[drew010]

it appears they are currently sorting the listings by id number in ascending order. all you need to do is change the mysql query to sort them in descending order. its probably something along the lines of
$query = "SELECT FROM listings ORDER BY listing_id ASC";
and could be changed to
$query = "SELCET FROM listings ORDER BY listing_id DESC";

[emeraldcat]

Thanks!!