My update query deletes instead.....

[Anon]

I'm a bit confused now

I have a form where I select various data from a table. When I change the data and press submit I have an update query which should update the data. Instead it seems to delete everything, quite confusing actually.

Can anyone see an error in this query, or perhaps have a clue on what can this problem?

$uplayer = "UPDATE player SET Firstname = '$firstname', Lastname = '$lastname', Birth = '$birth', Pos = '$pos', Length = '$length', Weight = '$weight', Drafted = '$drafted', Playerprofile = '$playerprofile' WHERE PlayerID = '$pID'";

$result = mysql_query($uplayer,$db_link);

[Anon]

Man, I'm sorry to bother you guys with this one.

I found out the problem

I had $firstname = $Post['firstname']
instead of $firstname = $POST['fistname'],

wasn't aware of that I had to always use CAPITALS when writing POST.

[edwardsbc]

For future reference, PHP variables are case sensitive (as described here: <http://www.php.net/manual/en/language.variables.php>)

So the super global variables must be addressed in all caps.