Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function getRandomUsers(){
- $query = $this->db->query('SELECT UserID FROM Persooninfo');
- $list = $query->result_array();
- shuffle($list);
- $query = $this->db->query('SELECT User.UserID, Voornaam, Achternaam, Geboortedatum, Woonplaats, User.Email, Geslacht, Biografie
- FROM Persooninfo, User
- WHERE Persooninfo.UserID = User.UserID and
- (User.UserID = ? or User.UserID = ? or User.UserID = ? or User.UserID = ? or User.UserID = ? or User.UserID = ?)',
- array($list[1],$list[2],$list[3],$list[4],$list[5],$list[0]));
- $list = $query->result_array();
- shuffle($list);
- return $list;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement