PHP MySQL add a empty raw between weeks on a table

Question

Hi i have a list of dates which fetched from mysql. and shows on a table like this

i need to show a empty row between weeks on my table

ex

04-03-2013  
05-03-2013
--------------- 
16-03-2013  
18-03-2013  
20-03-2013
---------------
01-04-2013
04-04-2013
---------------
05-04-2013
06-04-2013
---------------

i tried some codes with PHP but no luck, any one know how to do this kind of thing. thank you

What have you tried? What are you trying to do? I can't see any patterns with your lines — Pez Cuckow, Jan 07 '14 at 09:20

score 0 · Answer 1 · answered Jan 07 '14 at 09:26

0

while printing calculate the week of that particular day and store it in the array.For the next row onwards compare the values in the array using in_arry() with the calculated week if it is there just print the value if there is no value in the array push the value in to the array then print the line and print the value.

answered Jan 07 '14 at 09:26

Aravind Kishore

67
6

do you have some reference tutorials which i can follow – Suneth Kalhara Jan 07 '14 at 09:26
http://stackoverflow.com/questions/9567673/get-week-number-in-the-year-from-a-date-php – Aravind Kishore Jan 07 '14 at 09:37

PHP MySQL add a empty raw between weeks on a table

1 Answers1