hi there...i really need some help...
am develope training calender.. so in table i have training title n date for training ( from jan to dec). i have some problem when i wanna view all the training. fo example . in table i got 3 data:
1. training abc with date with month of january.
2. training def with date month of march and
3. training abc with date month of april.
so here i got one same training (training abc) but with different date.. so i want grap all the data but i want view it like this:
title jan feb march april
.............................................................................. ..
training abc jan april
training def march
insted of:
training abc jan
training def march
training abc april
in table i got:
training title;
date training start;
date training last;
as details see image below :
http://farm4.static.flickr.com/3459/3238749174_952c4c57e2_b.jpg
from here, training number 1 and 2 is the same training..but have different date. so i dont want to repeat the training row..
any idea how to do that.. i dont want to repeat the same training....i just want view it as onne training buat have diffenret date.. TQ so much