Updating MYSQL database

[Anon]

I get the following error message:

Warning: Supplied argument is not a valid MySQL-Link resource in /home/sites/site2/web/clandb/addmember.php on line 49

when using :

$sql = "UPDATE $table_name
SET
password = \"$password\",
WHERE userid = \"$userid\"
";

$result = mysql_query($sql,$connection);

the connection is correct.

[brandonschnell]

1) no its not. leave the $connection var from the mysql_query and see what happens. next, try mysql_connect() just before the query and make sure it doesn't return an error message.

2) you've got a comma before the WHERE in the sql query. this won't fix the connection issue, but try:

$sql = "UPDATE $table_name SET password = '$password' WHERE userid = '$userid'";