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!


EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum