Hello, i'm still trying to build a Google Map little App
I have a section for HOUSE
I have another section for RESTAURANT
What i want to do is to associate many RESTAURANTS with one HOUSE for exemple.
So in my HOUSE editor a have a field RESTAURANT-NEAR-HOUSE wich is populated from my RESTAURANT editor.
Here is my problem : i want te be able to display each field of my RESTAURANT editor calling from my RESTAURANT-NEAR-HOUSE field.
With "Get options from Database" stuff, i can only display one field (as the "value")
So i suppose i have to use "Get option from MySQL query"... but here i'm lost.
To summup, from the admin, when i create a new HOUSE entry, i give it a name, description and select as many checkbox wich are my RESTAURANT-NEAR-HOUSE entries.
And online for my restaurant-detail page i should have (assuming i have select checkbox for RESTAURANT-NEAR-HOUSE1 and 5
- name
-description
-restaurant-near-house1-NAME
-restaurant-near-house1-DESCRIPTION
-restaurant-near-house1-longitude
-restaurant-near-house1-lattitude
-restaurant-near-house5-NAME
-restaurant-near-house5-DESCRIPTION
-restaurant-near-house5-longitude
-restaurant-near-house5-lattitude
At last it is very important for me to IDENTIFY the "restaurant-near-house" fields, because i use longitude, lattitude, name, description to build my Google Map.
Hope it is clear.. and i hope it is possible.
Thanks