Plugin to retrieve users list?

Hello

I'm looking for a plugin or something similar to retrieve users list when i create a new field. What i need is to show a dropdown list box with existing users so an editor should choose one or multiple users form list. I have over 2000 users so i cannot add each user in dropdown...

How can i do that?

Hi,

If i have well understood :

You can use the field 'Select Multiple' with the parameter 'use SQL Query' to yes and 'field elements' with the query or
You can add some lines in your query to order the list for example.

In the form, when you 'll add an item, you'll have a multiple select list whith all the users of your site.

Rgds.

Hello I've a problem.
I want to built a field with a select list of countries. I have a list, jos_joomcountries with 245 Countries.
But when I put in the code

SELECT id AS value, title AS text FROM #_joomcountries

this error
Either the query is not correct or does not deliver results
is in the form.
Sorry I am not a programmer, only a sailer. Learning by doing :roll:

Someone can help me?

Hi,

Can you see in PhpMyadmin what is the name of your table fields?

May be for country you will not have id and title but something else.

After looking that, you can do :

where xx can be the primary_key of the row (may be ISO code for country) and yy the name of the country.

I hope it helps.

Bye

Hi, thanks for your quick responze.

the primary key is the id field from 1-245
code field for iso (like DE, GB, aso)
and title for the country

I played arround but everytime no result, nothing displayed.

That's strange,

Does the queries

return values in PhpMyadmin?