rajmohan Posted December 21, 2006 Share Posted December 21, 2006 Hai guys, i am having a table like this-------------------------------name | from_date | to_date -------------------------------a 27 dec 2006 30 dec 2006 b 1 jan 2007 4 jan 2007c 10 jan 2007 15 jan 2007d 16 feb 2007 20 feb 2007e 22 feb 2007 25 feb 2007f 2 mar 2007 5 mar 2007i have to display it like thisdec 2006---------27 - 30 ajan 2007---------1 - 4 b10 - 15 cfeb 2007---------16 - 20 d22 - 25 eetc.....help me any one now how to do this one Link to comment https://forums.phpfreaks.com/topic/31474-display-query-problem/ Share on other sites More sharing options...
glenelkins Posted December 21, 2006 Share Posted December 21, 2006 the table structure you described is this what you have in your sql database? Link to comment https://forums.phpfreaks.com/topic/31474-display-query-problem/#findComment-145813 Share on other sites More sharing options...
obsidian Posted December 21, 2006 Share Posted December 21, 2006 First, a question: how are you going to handle date ranges that cross months? For instance, when you have something like Jan 29 - Feb 3, how do you want it displayed? Link to comment https://forums.phpfreaks.com/topic/31474-display-query-problem/#findComment-145815 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.