how can I retrieve the stored data by date

I'm stuck at my project.. Can someone help me? Can someone help me please?? I have made an attendance list. Now that everything works, they have to enter the date they drove. Then the number of km per group, then indicate who rode in which group. Now I want to add an option that, for example, they enter the date of the previous ride. That you can then see the entered fields again. So you can actually change it back if necessary. But I have no idea how to do this. In the photo you can see, for example, a date entered, number of km and who rode where. so if I were to now change that date to another date that contains data. I should see filled fields.
No description
3 Replies
Rianẍa
RianẍaOP16mo ago
Rianẍa
RianẍaOP16mo ago
Is there no one that can help me? 🙁
MarkBoots
MarkBoots16mo ago
without seeing your mysql database schema, it's a bit of a guess, but based on your code, it think this query will do
SELECT * FROM 'ritten' WHERE 'datum' = '$selected_date'
SELECT * FROM 'ritten' WHERE 'datum' = '$selected_date'
where $selected_date is the value from your input I do have another tip for you: Try to keep your code (variable names) and comments in English. For me it was okay (I'm dutch), but I can image that people who don't know dutch are a bit hesitant to help because they could miss context.
Want results from more Discord servers?
Add your server