I need help with Querying a DB with PHP

[jamesisninja]

So... My PHP code just won't work for me, I've been trying to fix this for awhile now, I can't figure out what is wrong. The user selects a team name, and role from 2 drops downs that are populated straight from the Database so there can't be a spelling error, the database is already populated so it just has to update, but with the variables it won't work. I can't find why. It works fine if I change the variables to just strings.

http://pastebin.com/YjckxbUU

 

EDIT: I Finally fixed it after an hour of troubleshooting, let dis thread die.

[d4jsp]

Make sure you properly cast and secure your $_POST's and user input variables... If it's a localhost thing, disregard this message

[Nallown]

I'd say use the build in mysql_ methods to connect, execute and query with mysql

 

so to connect use $connect = mysql_connect("HOST", "USER", "PASSWORD") or die ("Failed to connect");

to select a database use mysql_select_db("DATABASE") or die("Could not connect to database");

to query use $query = mysql_query("SELECT * FROM users WHERE email='$email'");

etc......