Re: [PHP] Split/Group date together.

2013-07-18 Thread Larry Garfield
If I understand you correctly, I call what you're trying to do "PHP group by", and did a write up on it a few years back: http://www.garfieldtech.com/blog/php-group-by-with-arrays --Larry Garfield On 7/18/13 8:43 AM, Karl-Arne Gjersøyen wrote: Hello again. In my program I have this: mysql> S

Re: [PHP] Split/Group date together.

2013-07-18 Thread Bastien Koert
Normally, what I do here is handle that in the loop to display the records ... so start by adding an order by clause to keep the dates together SELECT * FROM transportdokument WHERE dato >= '16/7/2013' AND dato <= '18/7/2013' order by dato $prior_date = ""; $sHTML = ""; while($rows = mysql_fetc

[PHP] Split/Group date together.

2013-07-18 Thread Karl-Arne Gjersøyen
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 al