Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- offers:
- id | rid | name
- ------------------------------
- 1 | 1234 | mary
- 2 | 1235 | john
- 3 | 5342 | liam
- geo_in_off:
- offer_id | geo_id
- ------------------------------
- 1 | 1
- 2 | 2
- 3 | 3
- No | rid | name | geo
- ----------------------------------
- 1 | 1234 | mary | 1, 2
- No | rid | name | geo
- ----------------------------------
- 1 | 1234 | mary | 1
- 2 | 1234 | mary | 2
- require('../config.php');
- $sql ="SELECT * FROM `offers` LEFT JOIN `geo_in_off` ON `geo_in_off`.`offer_id` = `offers`.`id` ORDER BY `offers`.`rid`";
- $result = mysql_query($sql) or die(mysql_error());
- while ($row=mysql_fetch_assoc($result)) {
- echo "<tr><td>" . $i . "</td><td class="editable">" . $row['rid'] . "</td><td class="editable">" . $row['name'] . "</td><td>" .$row['geo_id'] . "</td></tr>" ;
- $i++;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement