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
Hi
So userid = what?
What do you want userid to equal?
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=
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'