F.schettino
Italian
Please, help a novice.
I don't understand where is the manual; can someone give me the link, please?
Question 1
I have a Table ("Comuni-Province-Regioni") with fields:
id | Municipatily | Province | Region
and a form in wich user have to insert Name-First Name- .... Municipatily-Province-Region ......
So, if user insert a Municipatily in the form, it is possible set (or only show) the corrisponding Province and Region.
I was able to get a list of Municipatily, Province and Region (using databasejoin plug-in and Table ) but I don't know how set (or show) automaticly Province and Region.
I tryed to put
where 'comune'={thistable}.comune
in
Question 2 (general question)
How can set the field to get than user choose from the list of Municipatily (text), but save its id (and show Municipatily, obviously)?
Thank you for your help.
I don't understand where is the manual; can someone give me the link, please?
Question 1
I have a Table ("Comuni-Province-Regioni") with fields:
id | Municipatily | Province | Region
and a form in wich user have to insert Name-First Name- .... Municipatily-Province-Region ......
So, if user insert a Municipatily in the form, it is possible set (or only show) the corrisponding Province and Region.
I was able to get a list of Municipatily, Province and Region (using databasejoin plug-in and Table ) but I don't know how set (or show) automaticly Province and Region.
I tryed to put
where 'comune'={thistable}.comune
in
- Joins clausule WHERE e/o ORDER BY (SQL)
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select 'nominativi.provincia' from 'nominativi' where 'comune'=Comuni-Province-R' at line 3 SQL=SELECT DISTINCT(`Comuni-Province-Regioni_1`.`Provincia`) AS value, `Provincia` AS text FROM `Comuni-Province-Regioni` AS `Comuni-Province-Regioni_1` WHERE select 'nominativi.provincia' from 'nominativi' where 'comune'=Comuni-Province-Regioni_1.comune ORDER BY text ASC
Question 2 (general question)
How can set the field to get than user choose from the list of Municipatily (text), but save its id (and show Municipatily, obviously)?
Thank you for your help.