Advertisement
Wessel

Untitled

Apr 24th, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.62 KB | None | 0 0
  1.     public function getRandomUsers(){
  2.             $query = $this->db->query('SELECT UserID FROM Persooninfo');
  3.             $list = $query->result_array();
  4.             shuffle($list);    
  5.             $query = $this->db->query('SELECT User.UserID, Voornaam, Achternaam, Geboortedatum, Woonplaats, User.Email, Geslacht, Biografie
  6.                 FROM Persooninfo, User
  7.                 WHERE Persooninfo.UserID = User.UserID and
  8.                 (User.UserID = ? or User.UserID = ? or User.UserID = ? or User.UserID = ? or User.UserID = ? or User.UserID = ?)',
  9.             array($list[1],$list[2],$list[3],$list[4],$list[5],$list[0]));
  10.             $list = $query->result_array();
  11.             shuffle($list);
  12.             return $list;
  13.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement