...

View Full Version : timetable with gridview ect.



sixtus
04-08-2007, 09:12 AM
I have a table in a mysql database with the fields: day, lesson, person. The posts could look like this:
monday, 2, Peter
sunday, 1, John
monday, 2, john
Tuesday, 4, Alice
...

I want to show the data in a timetable like this (, is the sign for at new column):
lesson,monday, tuesday, wednesday, thursday, friday, saturday, sunday
1, , , , , , , Peter
2, Peter John , , , , ,
3, ....
4,.....

So there can be empty cells and cells with more than one match from the table.

How do I create this timetable ? I hope someone can help me.
By the way I am using VB together with Mysql.

Lallo
04-11-2007, 03:42 PM
Can you explain the problem a bit more cause i afraid i didn't get it? By the way i think that your're asking about JOINT statements (SQL). Give me clear description of the problem and we will see what we can do!

Regards



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum