[eluser]Bigil Michael[/eluser]
this is my table structure
id checkindate checkoutdate name .......................
1 2012-01-17 2012-01-18 sajith
2 2012-01-17 2012-01-18 sajith
3 2012-01-17 2012-01-19 sajith
4 2012-01-17 2012-01-17 ram
5 2012-01-17 2012-01-18 kiran
6 2012-01-17 2012-01-18 kiran
i want to get the result like this
id checkindate checkoutdate name .......................
1 2012-01-17 2012-01-18 sajith
1 2012-01-17 2012-01-19 sajith
2 2012-01-17 2012-01-17 ram
3 2012-01-17 2012-01-18 kiran
that means iwant to print the same rows only once
can any one help me ????
thanks in advance...