OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
Amenities - displaying in alphabetical order (0 viewing) 

Joomla Real Estate

Go to bottom Favoured: 0

Amenities - displaying in alphabetical order

damianradek (User)
Fresh Boarder
Posts: 13
graphgraph
User Offline Click here to see the profile of this user
Amenities - displaying in alphabetical order 4 Years, 11 Months ago
Karma: 0  
Hi,

I would like to display amenities in alphabetical order (to avoid mess, for easier reading). What file is to be edited and how can I do it?
Big thanks.

Regards,
Radek
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8230
graph
User Offline Click here to see the profile of this user
Re:Amenities - displaying in alphabetical order 4 Years, 11 Months ago
Karma: 101  
Hello

You need in file
{site}/components/com_realestatemanager/realestatemanager.php

find code look like:

Code:

        $query = "SELECT f.* ";
        $query .= "FROM #__rem_feature as f ";
        $query .= "LEFT JOIN #__rem_feature_houses as fv ON f.id = fv.fk_featureid ";
        $query .= "WHERE f.published = 1 and fv.fk_houseid = $id ";
        $query .= "ORDER BY f.categories";
        $database->setQuery($query);
        $house_feature = $database->loadObjectList();



and replace it to code like

Code:

        $query = "SELECT f.* ";
        $query .= "FROM #__rem_feature as f ";
        $query .= "LEFT JOIN #__rem_feature_houses as fv ON f.id = fv.fk_featureid ";
        $query .= "WHERE f.published = 1 and fv.fk_houseid = $id ";
        $query .= "ORDER BY f.categories, f.name";
        $database->setQuery($query);
        $house_feature = $database->loadObjectList();



Please backup file first

Regards
Andrew
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
damianradek (User)
Fresh Boarder
Posts: 13
graphgraph
User Offline Click here to see the profile of this user
Re:Amenities - displaying in alphabetical order 4 Years, 11 Months ago
Karma: 0  
Hi,

It works great! Thank you
Logged Logged
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8230
graph
User Offline Click here to see the profile of this user
Re:Amenities - displaying in alphabetical order 4 Years, 11 Months ago
Karma: 101  
You are welcome !

Regards
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
Go to top
»