OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
OrdaSoft forum Joomla Real Estate Forums Joomla Real Estate
Add additional fields in Featured module (0 viewing) 

Joomla Real Estate

Go to bottom Favoured: 0

Add additional fields in Featured module

#8152
bekaheni (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Add additional fields in Featured module 12 Years, 6 Months ago
Karma: 0  
Hi there,

Can you tell me if it is possible to add additional fields into the Featured module?

eg I would like to add also the City field.

I have managed to add the location twice just to make sure I can do it! and it works fine.

ie I add this line echo "<div id='fest_location'>{$row->hlocation}</div>"; and thats works fine.

But I have tried 'hcity' or any other field for that matter and it wont display !

Any ideas?

Cheers
Nick
Logged Logged
The administrator has disabled public write access.
#8154
admin (Admin)
Admin
Posts: 8484
graph
User Offline Click here to see the profile of this user
Re:Add additional fields in Featured module 12 Years, 6 Months ago
Karma: 102  
Hello Nick,

At module top you see:

Code:
$query = "SELECT h.htitle, h.id, h.image_link, h.hits, c.id AS catid, h.price, h.published, h.priceunit, h.hlocation, h.featured_clicks, h.featured_shows
        n FROM #__rem_houses AS h
        n LEFT JOIN #__rem_categories AS hc ON hc.iditem=h.id
        n LEFT JOIN #__rem_main_categories AS c ON c.id=hc.idcat
        n WHERE (".$s.") and ( h.featured_clicks > 0 or h.featured_shows > 0 ) ";


You need add "hcity" - to select operator first some like:

Code:
$query = "SELECT h.htitle, h.id, h.image_link, h.hits, c.id AS catid, h.price, h.published, h.priceunit, h.hlocation, h.featured_clicks, h.featured_shows, h.hcity 
        n FROM #__rem_houses AS h
        n LEFT JOIN #__rem_categories AS hc ON hc.iditem=h.id
        n LEFT JOIN #__rem_main_categories AS c ON c.id=hc.idcat
        n WHERE (".$s.") and ( h.featured_clicks > 0 or h.featured_shows > 0 ) ";


Thanks,
OrdaSoft team
Logged Logged
Last Edit: 2013/05/29 07:31 By admin.
The administrator has disabled public write access.
#8170
bekaheni (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Re:Add additional fields in Featured module 12 Years, 6 Months ago
Karma: 0  
Ai!

Works perfectly!

Cheers
Nick
Logged Logged
The administrator has disabled public write access.
#8192
admin (Admin)
Admin
Posts: 8484
graph
User Offline Click here to see the profile of this user
Re:Add additional fields in Featured module 12 Years, 6 Months ago
Karma: 102  
Hi Nick,

You may vote for us on joomla.org and write excellent review

If you will have some error or questions, please write

Thanks,
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
Go to top
Powered by OrdaSoft
 
What are you looking for?
»