Date: 06/19/05 (PHP Community)    Keywords: database

I have a "house cup" for my Harry Potter board, and I am trying to reconfigure it to better use functions and to use Smarty. I'm not sure if I'm doing this best way.

I currently have a form that lists all users and gives the admins the optoin to enter points earned and points lost for every user. The way I've got it set up currently, the filed names are "usernamepos" and "usernameneg." After submitting, I then re-get all the usernames, re-make the strings, and, if usernamepos or usernameneg is not zero, I run the query to update the database.

This doesn't impress me as being particularly efficient, but I can't figure out any other way to do it. Thoughts?

Source: http://www.livejournal.com/community/php/309894.html