hi..i'm newbie in sql..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,februar y 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..
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,februar y 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..
Comment