I actually got quite good fix for my problem using the following code:
$randnum = rand(1, 50);
$query = mysql_query("SELECT Stoelnummer FROM reserveringen WHERE Voorstellingsnummer = '$Voorstellingsnummer' AND Stoelnummer = '$randnum'", $db);
while(mysql_num_rows($query) == 1){
...
I'm able to get a tally table for 5 days using level field :
WITH cte AS (
SELECT CAST('2021-03-01' AS DATE) AS a,
0 AS LEVEL
union ALL
SELECT DATEADD(DAY, 1, a),
LEVEL + 1 AS LEVEL
FROM cte
WHERE LEVEL < 4
)
SELECT * FROM cte
but I tried without level :
WITH cte AS (
SELECT CAST('2021-03-01' AS DATE) AS a
union ALL
SELECT DATEADD(DAY, 1, a)
FROM cte
WHERE DATEADD(DAY, 1, a) < GETDATE()
)
SELECT *
FROM cte
oh shi*... it also works. I don't know why it didn't work before