Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Mar 2007
    Thanked 0 Times in 0 Posts

    timetable with gridview ect.

    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.

  • #2
    Regular Coder
    Join Date
    Sep 2006
    Skopje, Macedonia
    Thanked 0 Times in 0 Posts
    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!



    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts