Split/Group date together.
| From: | Karl-Arne Gjersøyen | Date: | Thu, 18 Jul 2013 13:43:01 +0000 |
| Subject: | Split/Group date together. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-321632@lists.php.net to get a copy of this message | ||
Hello again.
In my program I have this:
mysql> SELECT * FROM transportdokument WHERE dato >= '16/7/2013' AND dato
<= '18/7/2013';
This list all reccrds for 3 days. I need a way to split it up for every day
even when the requst is as above and don't know in what way I can do it.
I like to have all records for day 16 in one table in PHP/HTML and all
records for day 17 in another table.
i.e, Day 16 have 5 rows and day 17th and 18th have 7 and 8 rows.
I hope for your help and advice to do also this correct.
Thank you for your time and effort!
Karl