Advertisement
Guest User

Untitled

a guest
Jul 27th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. offers:
  2. id | rid | name
  3. ------------------------------
  4. 1 | 1234 | mary
  5. 2 | 1235 | john
  6. 3 | 5342 | liam
  7.  
  8. geo_in_off:
  9. offer_id | geo_id
  10. ------------------------------
  11. 1 | 1
  12. 2 | 2
  13. 3 | 3
  14.  
  15. No | rid | name | geo
  16. ----------------------------------
  17. 1 | 1234 | mary | 1, 2
  18.  
  19. No | rid | name | geo
  20. ----------------------------------
  21. 1 | 1234 | mary | 1
  22. 2 | 1234 | mary | 2
  23.  
  24. require('../config.php');
  25. $sql ="SELECT * FROM `offers` LEFT JOIN `geo_in_off` ON `geo_in_off`.`offer_id` = `offers`.`id` ORDER BY `offers`.`rid`";
  26. $result = mysql_query($sql) or die(mysql_error());
  27.  
  28. while ($row=mysql_fetch_assoc($result)) {
  29. echo "<tr><td>" . $i . "</td><td class="editable">" . $row['rid'] . "</td><td class="editable">" . $row['name'] . "</td><td>" .$row['geo_id'] . "</td></tr>" ;
  30. $i++;
  31. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement