When I execute it in my database, I get more dates for different days than the my actual output. the $dayt='1' is monday, '2' is tuesday and so on until friday, how can I fix this? My output is in the image
The real output should be 4 dates on monday not just 1. 3 on wednesday and one on friday
PHPMySQL Server
Last Comment
Jazzy 1012
8/22/2022 - Mon
Ray Paseur
Without seeing your data, we're just guessing. A common approach might be to remove SELECT * and instead SELECT only the columns you want. SELECT * is an anti-practice, and there is rarely any good reason to use it. Another common approach is to expand the restrictions of the WHERE clause and add a LIMIT clause.
Jazzy 1012
ASKER
Ok so how do I make the wednesday and friday rows shift up? I dont want it to skip a row everytime