Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerGallery › PowerGallery General / Announcements › Gallery Order on Admin Page

Gallery Order on Admin Page

Thread began 3/24/2010 11:24 am by dennis.hacker262917 | Last modified 3/24/2010 11:49 am by Jimmy Wu | 884 views | 1 replies |

3/24/2010 11:24 am | #1 dennis.hacker262917

Gallery Order on Admin Page

Is there a way to change the order in which the galleries are listed on the Admin Page? I would rather have the newest ones at the top of the list, since often times once I finish a gallery it isn't edited again.

3/24/2010 11:49 am | #2 Jimmy Wu

To change this, you will want to open the choosegallery.php page in the Admin folder of your PowerGallery and find the query that looks like this:
$result_gallery = mysql_query('
SELECT *
FROM pg1_gallery
ORDER BY id ASC');

Modify the ORDER BY clause to look like this:
$result_gallery = mysql_query('
SELECT *
FROM pg1_gallery
ORDER BY id DESC');

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.