delete from mysql table

[Anon]

I'm working on a project, and one part of it is not working. This part is supposed to simply delete a record from a table. The code is as follows:

<?

$user = "xxxxxxxxx";
$pass = "xxxxxxxx";
$db = "music";
$connection = mysql_connect($server, $user, $pass) or die ("Unable to connect to database.");
$query = "delete from posts where login = '$login' ";
$result = mysql_db_query($db,$query ,$connection);
mysql_close ($connection);
echo "RECORD WAS DELETED";

?>

======================
The result of the above is RECORD WAS DELETED without any error messages. But when I check the table, the record is still there.

Note: $login is a variable supplied from a form earlier in the script. Any ideas?

Richie.

[lucidfx]

if (!($link=mysql_connect("localhost","username","password")))
{
print "Failed to connect to database!";
}

mysql_select_db("database",$link);

mysql_query("DELETE FROM posts where login='$login')",$link);

Try that i think that should work fine for you.

[lucidfx]

I didnt change everything to fit your needs, make sure to name
mysql_select_db("database",$link);

database, the name of your database.