Deleting data from database table according to id and userid

Question

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.

Comments

Why $sql->insert('usergames', $delete);?

insert() insert data to database.  

use delete()   

I am sure that there are examples in code and in official doc.

Answer 1

Please refer to the develop reference manual here: https://e107.org/developer-manual#database

$sql->delete("user", "user_id=2");

The second parameter is the WHERE argument. 

Comments

Can you please post a link to your complete code? For example by sharing the link to your Github repository or by using Gist 

---

https://gist.github.com/3l3ktr0n/1df9c6f76cf1487d5608f0c779575e0d

---

Okay, I just figured it out. I'm still learning php, still green. Thanks anyway.

---

Glad to hear you got it sorted out!