Forum


Calc Builder Support

Calc Builder support
Forums
No se permite escribir sin estar logado. Por favor, login

Getting names and values from database 14.03.2012 20:09

Hello!

I have a mysql database with names of cities, each city has a zone value.
Please, help me to write SQL to get list values from database.

MySQL database name is 'tr_bilet'

Table name is 'city_zone'

Columns are 'city' and 'zone'

Thank you!

Re: Getting names and values from database 15.03.2012 09:41

Hello,

To fill results in option list using SQL you should 'name' columns as follows: To fill value at option list, use 'as mvkey' in SQL sentence and to get view Name use 'mvvalue'

Here are an example of an SQL to get all users from your joomla:

select id as mvkey, name as mvvalue from #__users


So you only have to replace table and column names for the ones on your database.


Hope this helps. Regards,

Moonsoft Team.
Moonsoft Team
www.moonsoft.es

Re: Getting names and values from database 15.03.2012 10:43

Thank you! )
Are you satisfied with our products/services/support?
Please help us to keep improving, add a review at  joomla extensions site and  magento connect
FaLang translation system by Faboba

Lo que nuestros clientes opinan de nosotros