Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.67 KB | None | 0 0
  1. <?php
  2. $conn = mysql_connect("localhost", "root", "") or die(mysql_error());
  3. mysql_select_db("coke") or die(mysql_error());
  4. $query = "SELECT DISTINCT * FROM owner";
  5. $result = mysql_query($query);
  6. while($row = mysql_fetch_assoc($result)) {
  7.     $owner = $row['owner'];
  8.     $query2 = "SELECT * FROM tablo WHERE owner = '$owner'";
  9.     $result2 = mysql_query($query2);
  10.         while ($row2 = mysql_fetch_assoc($result2)) {
  11.         $p[] = $row2['owner']." - ".$row2['folder_name']. " - ". $row2['user_id']. " - ". $row2['username']." - ". $row2['parent_folder']. " - ". $row2['permission']. " - ". $row2['permission_type']. " - ". $row2['group_name']. " - ". $row2['path'];
  12.     }
  13.     echo "<pre>";
  14.     print_r($p);
  15. }
  16.  
  17. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement