it's definitely not random.. i've taken the rand out of mysql and put it into the php side instead..

that works..