Can I update a user's accessList with a mysql update query?

4 posts by 2 authors in: Forums > CMS Builder
Last Post: November 21, 2010   (RSS)

Re: [markr] Can I update a user's accessList with a mysql update query?

By Dave - November 20, 2010

Hi Markr,

I've attached a sample form that creates user accounts. Have a look at the code and comments for an example. It has some example PHP/MySQL code for setting the access levels.

Hope that helps! Let me know any questions.
Dave Edis - Senior Developer
interactivetools.com
Attachments:

usersignup_001.php 5K

Re: [Dave] Can I update a user's accessList with a mysql update query?

By markr - November 21, 2010

This is perfect...will work nicely. Thanks.

Btw, if you don't mind explaining, I'm curious, why does phpMyAdmin list all my cms_ tables normally but cms_accesslist is listed under cms, like a sub table or something?

Re: [markr] Can I update a user's accessList with a mysql update query?

By Dave - November 21, 2010

Hi markr,

I don't use phpMyAdmin much, but I did a quick search and it sounds like it's because we happened to use double underscores in that table name. See:
http://board.flashkit.com/board/showthread.php?t=790497

So it's a phpMyAdmin "feature" :)

Hope that helps!
Dave Edis - Senior Developer
interactivetools.com