i've been doing while loops for this problem .. i dont think its the right way though.
i have a set of boxes each with a boxid(apart from the first), which is the id(mysql) of the previous box.
box 1 has id 1
box 2 has id 2 and boxid 1,
box 3 has id 3 and boxid 2 etc
you see the boxid is the same as the previous id.
i want 10 boxes to display , when i'm trying to loop this i am using a while loop, but i keep on having to use another while loop inside, just to match the boxid with previous id to get the next box to display. so i would have to do 10 while loops inside one another, which isn't good practice.
is there a better way to do this? for loop?
box 1 has id 239
box 2 has id 456 and boxid 239,
box 3 has id 123 and boxid 456 etc