View Full Version : timetable with gridview ect.

04-08-2007, 08: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, ....

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.

04-11-2007, 02: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!