Re: How do I delete a composite key?

nitrox . wrote:

Im trying to delete a composite key but cannot figure out the proper format. Would somebody tell me where im messing up? I have an url that is supposed to send the member id and game id to a delete query. And the delete query is supposed to grab the id's based on type. This is the link: <a href=\"member_commit.php?action=remove&type=Member&id={$record->Member_id}&gametype=Game&id={$record->Game_id}\">[GAME REMOVAL]</a></td>\n"; <snip>

$sql = "DELETE

          FROM xsm_membergames
          WHERE Member_id = '" . mysql_real_escape_string((int)$_GET['id']) . " .
    AND Game_id = '" . mysql_real_escape_string((int)$_GET['id']) . "'";

Your URL contains 2 instances of a GET variable named, which you then use in the SQL query. In this instance $_GET['id'] will contain just the Game_id. Change the name of one or both IDs and you should be ok. -Stut -- http://stut.net/