mysql error update function

Anon

can someone tell me what the error is here...please

$sql="UPDATE player_stats SET Name='$Name' Number='$Number' Avg='$Avg' G='$G' AB='$AB' R='$R' BB='$BB' H='$H' 2B='$twoB' 3B='$threeB' HR='$HR' RBI='$RBI' SB='$SB' WHERE Name='$playername'";
$result = mysql_query($sql);

brandonschnell

you've got multiple errors. also use an auto increment primary key id to refer to specify rows unless you're searching for something. so "WHERE Name='$playername'" would be "WHERE Id = '$id'".

$sql="UPDATE player_stats SET Name='$Name', Number='$Number', Avg='$Avg', G='$G', AB='$AB', R='$R', BB='$BB', H='$H', 2B='$twoB', 3B='$threeB', HR='$HR', RBI='$RBI', SB='$SB' WHERE Name='$playername'";
$result = mysql_query($sql);

Anon

thank u...

and i know the id thing..only i designed this site before i started learning php and used a script that displayed the whole database and you couldnt hide any fields..very ugly you know...

THANK YOU SO MUCH...🙂