Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

Dropdown Save Data

shadowgun1102 21 Jun, 2019

Hello, I have a dropdown that reads the data from the REGION table and returns the data ID and NAME and another CITY table that is related to its REGION.In the database, only the ID of both tables is saved, because this ID is the data-value.I need the NAME field to be saved instead of the ID, how can I solve this problem?
Thanks!

GreyHead 21 Jun, 2019

1 Likes

Hi shadowgun1102,

You can use the Name as the value in the dropdown as well as for the text; or

You can look up the Name(s) from the IDs before the DB Save action; or better

You can continue to save the IDs and look up the names when you need them.

Bob

healyhatman 22 Jun, 2019

shadow the third option is the right answer and you should to that.

This topic is locked and no more replies can be posted.