Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
41
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 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. $row = mysql_fetch_assoc($result);
  7. while($row = mysql_fetch_assoc($result)) {
  8. $owner = $row['owner'];
  9. $query2 = "SELECT * FROM tablo WHERE owner = '$owner'";
  10. $result2 = mysql_query($query2);
  11. $row2 = mysql_fetch_assoc($result2);
  12. while ($row2 = mysql_fetch_assoc($result2)) {
  13. echo $row2['owner']." - ".$row2['folder_name']. " - ". $row2['username'];
  14. echo "<br>";
  15. }
  16. echo "<pre>";
  17.  
  18. }
  19. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement