Help with PHP/MySQL

[hiroyaw]

Hello, I need help creating a PHP database, user CP and an admin CP. I've taken a look at tutorials but what I'm trying to do is pretty complicated so I was hoping you guys could lead me to the right direction, whether it be a specific program, tutorial or some general advice.

I want to make a control panels users can log in to, and set certain options from a dropdown. Say there are 3 users in the database, user A, B, and C. They will each be able to choose option 1, 2, or 3 in their corresponding control panels. Option 1 will add 10 to their "points", which is recorded in the database. Option 2 will add 20, and 3 will add 30. I want to be able to have an "update" function on an admin CP, which will update the database according to which option each user chose. If user A picks option 1, user B picks 2, and C picks 3, their variables in the database will update to 10, 20 and 30 accordingly.

Where should I start reading if I wanted to do something like this? I know it's possible because a friend of mine used to have a PHP script like this, but I've lost touch with him. I'm also thinking of getting NuSphere PhpED if it will help.

[batman1]

read w3schools.com the php and SQL sections.

then for more advance stuff read php.net

good luck;)

[mattura]

The login control panel thing is the hardest part. Look up sessions and logins in php - they are a lot of work.
The selection thing is pretty easy, just create a form and on submit get php to update the sql database.