[TheMaster1]

Im trying to delete a record from a table in the database and i want it to delete a record if to values are in the table

 mysql_query("DELETE FROM message WHERE user='$user' AND sender='$sender'"); 

I do this and it doesn't delete the data in the database

am i doing something wrong?

can you use this:

WHERE user='$user' AND sender='$sender' 

This post has been edited by TheMaster1: 22 July 2011 - 08:10 AM

[Jstall]

There is nothing wrong with your syntax as I can see. Put the sql in a variable so you can echo it out and see the query:

$sql = "DELETE FROM message WHERE user='$user' AND sender='$sender'"; 
if(!mysql_query($sql))
{
  echo "Problem with query $sql";
}

Then you can take the output and feed it directly to MySQL and see if any error message pop up.

[EnvXOwner]

Well, I've never done a query like that. Try my way:

mysql_query("DELETE FROM `message` WHERE `user` = '" . $user . "' AND `sender` = '" . $sender . "'") or die(mysql_error());

What I did is basically the same thing I did. Try what Jstall said.

This post has been edited by EnvXOwner: 22 July 2011 - 08:12 AM

[TheMaster1]

thanks for the help guys but the problem was i declared the $user and $sender below the mysql_query delete in a while loop so it doesn't no what the $user and $sender is.

what a complete fail lol

[EnvXOwner]

That's alright, everyone makes those mistakes every now and then.