bath loop with mysql – how to use loop item in query

I have the below script. I want to execute the same query over and over again, with different dates.
The below doesn't work because it says $i is not valid
Anyone got any ideas?
Thanks

View on Stack Overflow