$rowsindata = $Cars->numrows(); $random = rand(1, $rowsindata); $random2 = rand(1, $rowsindata); $random3 = rand(1, $rowsindata); if ($random == $random2) { if ($random2 == $rowsindata) { $random2--; } else { $random2++; } } if ($random == $random3 || $random2 == $random3) { if ($random3 == $rowsindata) { $random3--; } else { $random3++; } } if ($random == $random3 || $random2 == $random3) { if ($random3 == $rowsindata) { $random3--; } else { $random3++; } // run again to make sure that the second time it hadent changed to the other random numbers } $array = $Cars->dataquery($random); $array2 = $Cars->dataquery($random2); $array3 = $Cars->dataquery($random3); echo json_encode(array("a1" => $array['id'], "a2" => $array['ref'], "a3" => $array['heading'], "a4" => $array['text'], "b1" => $array2['id'], "b2" => $array2['ref'], "b3" => $array2['heading'], "b4" => $array2['text'], "c1" => $array3['id'], "c2" => $array3['ref'], "c3" => $array3['heading'], "c4" => $array3['text'])); $conn->close();