i created a table which has 5 field it's like
ID(auto increment)
Reply_id
Name
and so on
my problem is i have a data like below
ID Reply_id Name
1 5
2 1
3 7
4 1
5 2
6 1
7 5
and so on...
now if i want to select Name where Reply_id=1 then it takes lot of time so is it possible to arrange like this
ID Reply_id
1
1
1
5
5
2
2
2
and so on...
please help me
thanks