Help!!!

[mart]

how can I insert info into an existing row in a table?

I have written something with my lilmited knowledge of the proper syntax of mySQL. Please point to the proper direction.

$query = "INSERT INTO players WHERE userid ='$player_number' (memberstatus) VALUES ('$status')";
mysql_query($query,$link)or die(mysql_error());

Thanks.

Mart.

[devinemke]

you don't want an INSERT query, you want an UPDATE query:

$query = "UPDATE players SET memberstatus = '$status' WHERE userid = '$player_number'";
mysql_query($query, $link) or die(mysql_error());

[mart]

Thanks!

It worked beautifully.