I have a table that consist of gameid, userid and username. What I want is the user to be able to delete a game from the list without deleteing other users games with the same id. For example
table usergames.............. user Blabla with USERID 1 deletes game with gameid 1 from the list without affecting other entries
gameid, userid, username
1 1 Blabla
1 2 Qwerty
2 1 Omg
3 4 Wadaduck
if (isset($_POST['delete_game'])){
$delete = array(
'gameid' => $gameid,
'userid' => USERID,
'username' => USERNAME
);
$sql->insert('usergames', $delete);
$text = e107::getMessage();
$text->addSuccess('Game removed from the list.');
echo $text->render();
Doesn't work and other means just delete the whole table.