$lidnummer = $_POST['lidnummer'];

            $q2_select_sports = "SELECT * FROM korting_kaartjes WHERE lidnummer = '".$lidnummer."' ORDER BY Id DESC LIMIT 0,1";
            $r2_select_sports = Core::$db->query($q2_select_sports);
            $sports2 = Core::$db->fetch_object_all($r2_select_sports);

            $checkid = $sports2[0]->lidnummer;

            if(empty($checkid)) {
                $kortingleft = 3;
            } else {
                // kijkt hoeveel korting er nog over is
                $kortingleft = $sports2[0]->korting_left;
                echo $kortingleft;

                if($kortingleft == 3) {
                    echo 'korting was 3';
                } else if($kortingleft == 2) {
                    echo 'korting was 2';
                } else if($kortingleft == 1) {
                    $kortingleft = 0;
                } else if($kortingleft == 0) {
                    header("Location: korting.html");
                    exit;
                }
            }