3 replies to this topic

[toxifyshadow]

Sorry about the title, I couldn't think of a title.

So right now I'm working on a user system for a website. So far all I have are the id, username, and pw parts of the table. I'm trying to find out if I can add a rank system too.
Kinda like the codecall thing, you start as a "newbie" then after you reach a certain number of posts you advance to "learning programmer" and so on. I want to add something similar. How would I make the title change after that user reaches a certain goal. I coudn't think of an example either so I had to use codecall.

[WingedPanther]

You would use an update statement.

[toxifyshadow]

Ok.

[inenigma]

Yes, you would use an UPDATE statement after you had determined that the user had first achieved something (number of posts for example). You first need to determine what your criteria is to perform whatever update.