What I have is a result in more than 1 page(if there's many) and displayed in random order. But whenever there's more than 1 page for the search, same item is displayed in 2nd page and some results are ommited. How can i sort those results in random order and maybe use temporary table to store it. and display it from there.