2删除，只有一个工作[POSTGRESQL]

Question

I'm literaly going crazy over this one. So I have my gamePage.php file where I can see all the info about a single videogame. The button delete invokes the following code

    if(isset($_POST['delete'])){
        $query="DELETE FROM shop.videogame WHERE IDVideogame='$id'";
        pg_query($conn, $query);
        $query="DELETE FROM shop.storage WHERE videogame='$id'";
        pg_query($conn,$query);
        echo 'Game deleted, click the "Go Back" button';            
     }

What actually happens is that only the second Delete works. The videogame is deleted from the storage table, but not from the videogame table. What's even stranger is that if I click a second time the button, the first DELETE finally works.

In other words one is supposed to click for 2 times the same button for no reason.

Answer 1

I guess shop.storage.videogame is a ForeignKey to shop.videogame.IDVideogame.

If I have right, then switch delete statements.

$query="DELETE FROM shop.storage WHERE videogame='$id'";
pg_query($conn, $query);
$query="DELETE FROM shop.videogame WHERE IDVideogame='$id'";
pg_query($conn, $query);