prcollin Posted May 15, 2009 Share Posted May 15, 2009 Say I have boat AA and someone reserves it from 11am to 1pm then someone else from 2pm to 5pm how do i get the results to display like this below. My problem is every time someone reserves a boat it puts a new entry in but i dont want the boat name to return 2 times Boat 9am 10am 11am 12pm 1pm 2pm 3pm 4pm 5pm AA O O X X X X X X X AA O O O O O X X X X AB O O O O X X X X X in the display page I just want one boat name with all time slots filled in on one row. like below Boat 9am 10am 11am 12pm 1pm 2pm 3pm 4pm 5pm AA O O X X X X X X X AB O O O O X X X X X Link to comment https://forums.phpfreaks.com/topic/158204-how-could-i-get-this-result/ Share on other sites More sharing options...
Ken2k7 Posted May 15, 2009 Share Posted May 15, 2009 I'll probably have to see some code. Link to comment https://forums.phpfreaks.com/topic/158204-how-could-i-get-this-result/#findComment-834473 Share on other sites More sharing options...
prcollin Posted May 15, 2009 Author Share Posted May 15, 2009 I'll probably have to see some code. Basically what I have is a database with these results <u> Boat Name DateOut TimeOut DateIn TimeIn</u> Ab Phil 5/5 10:00 5/6 22:00 Ab Scott 5/5 06:00 5/5 09:00 And for an output I want to display these two results but as time slots reserved but since the boat is the same i want it to display only one row with all the time from both outputs. So the display will show each hour from 6am on 5/5 until 10pm on 5/6 as reserved. Link to comment https://forums.phpfreaks.com/topic/158204-how-could-i-get-this-result/#findComment-834480 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.