Jump to content

How could I get this result


prcollin

Recommended Posts

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

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.

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.