52 Posts
rafiki
7 years ago
3
Topic

please am not to familiar with sql so am having issues using the dynamic field. i want it to generate a list of all registered users so i tried setting up the field but am having issues. this is what i did

table= #_users where= userid option name= username option value=id.

this what i did to my best knowledge but its not working showing me an error. please whats the right syntax. thank you

Get a Book for SEBLOD
1283 Posts
Bucklash
7 years ago
2
Level 1

Hi 

So userid = what?

What do you want userid to equal?

52 Posts
rafiki
7 years ago
1
Level 2

i dont get. there is no field to add user id. am sing the dynamic field so the field options are just

table =

where=

option value=

option name=

1283 Posts
Bucklash
7 years ago
0
Level 3

Hi

If it is a list of registered users then 

table: #__users

option name:  name(or whatever)

option value: id

where: state=1 (or is published, have to check that, or maybe leave blank, depends on what your conditions are) 

In your where section you have 'where userid'  but it needs to be 'where userid = something'

select-dynamic-field-options-user-s-own-content

Get a VIP membership