Results 1 to 1 of 1

Thread: how to count and insert into database by month

  1. #1
    Join Date
    Mar 2008
    Posts
    4
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Red face how to count and insert into database by month

    hi..i have a big problem..i'm used db access and asp code in my system..hope someone can help me to fix this issue..
    here i have two table..1) eachclick 2)month
    1st (in table eachclick)

    button clicked date time
    1 1 19 mac 2008 2:30pm
    2 1 19 mac 2008 2:31pm
    3 1 19 mac 2008 2:32pm
    1 1 19 mac 2008 2:33pm
    1 1 19 april 2008 9:00am
    2nd(in table month)

    button january feb mac april may june
    1 0 0 0 0 0 0
    2 0 0 0 0 0 0
    3 0 0 0 0 0 0
    That's the sample table that i've create..
    i don't know how to count the clicked and insert it into the table month..
    i want to know how much clicked in january,february and so on and separate the button like i draw in table month...
    may someone help me to give the code..tq for your honest..
    Last edited by lyter; 03-19-2008 at 08:44 AM.

Bookmarks

Posting Permissions

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