• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Sort and Exclude user Auto-populate a list

Sort and Exclude user Auto-populate a list 6 years 1 month ago #38910

  • s.span
  • s.span's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 8
Hi,
I have been playing around with the code on this page to select the names from the user table to achieve two things:
1) Sort the list alphabetically and leaving the "Please Select" option as the first option,
2) Exclude one specific user from the list

I can successfully extract all the names from the user table and get them to display. I am however unable to achieve 1 and 2 from above. My knowledge lacks severely as I cannot seem to get it to work.

Could anyone give me some pointers as how to get that to work?

Thanks!
The administrator has disabled public write access.

Sort and Exclude user Auto-populate a list 6 years 1 month ago #38921

  • s.span
  • s.span's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 8
Must have been too late when I was trying to do this, I think I got it figured out...
$db->setQuery("SELECT name, name FROM users WHERE id NOT LIKE '988' ORDER BY name")
does the trick...

Thanks!
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!