[Resolved] A question about a LOOP

[sunnyside]

I've developed a time schedule module. Left side display time and right site display people information during a specific time period. This is developed by a loop function. The following is what it looks like:
...
8:10 Mike
8:20 Mike
8:30 Mike
8:40
8:50 John
9:00 John
9:10
...

The above format is working fine. But right now I would like to display people's other info in same for loop as well:
...
8:10 Mike
8:20 tel: [phone]
8:30 Banking
8:40
8:50 John
9:00 tel: [phone]
9:10
...

My question is how I can display different info during the for loop.

thank you!

[devinemke]

how/where is all of this data stored? in a database i assume? if so what is the data structure?

[sunnyside]

The left side of time is created during a loop. No database related with it.

The right side information is stored in a table-"tbl_appointment", inside has fields like: (id, start_time, end_time, date, contact_id ...); the "contact_id" is related with another table which contains people name, phone number and other information.

What I did in this for loop is:
Check time in "tbl_appointment", if there 's no start_time same as my left side of time, will display nothing; otherwise, display relative people name

[devinemke]

ok then. it sounds like you are already querying the tbl_people table to get the contact_id and also querying the table with all of the peoples names. simply expand you query to grab the other data (phone #'s, etc...)

[sunnyside]

Originally posted by devinemke
ok then. it sounds like you are already querying the tbl_people table to get the contact_id and also querying the table with all of the peoples names. simply expand you query to grab the other data (phone #'s, etc...)

Hi, thank you for your reply. Probably I didn't make myself clean enough. My for loop is to make time list for left side. In this case, my for loop is increased every 10 min. So if there's an appointment for Mike from 8:10-8:30, OK, find it from tbl_appointment, then I only can display same info (name or phone # or something else) 3 times from 8:10-8:30. But what I want is: start time 8:10 display name only, then jump to next loop 8:20, display phone #, next loop 8:30, display others....

[devinemke]

what if Mike has an appointment at 8:10 and Jane has one at 8:20? what would be displayed at 8:20, Mike's phone number or Jane?

[sunnyside]

Originally posted by devinemke
what if Mike has an appointment at 8:10 and Jane has one at 8:20? what would be displayed at 8:20, Mike's phone number or Jane?

This will be the second thing I will check after I finish the first part. In this case, it will only display name but not other info. But this "appointment system" have min time of 30 minutes for each appointment

[sunnyside]

This problem has solved! well, cause my function is very complex, so it's kind of hard to explain the solution here.