Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $mysql = new mysql();
- $mysql->connect();
- $data = $mysql->query("SELECT
- i.id,
- i.imagepath,
- i.galleryid,
- g.galleryowner,
- g.id,
- g.galleryname,
- g.gallerypreview
- FROM `tbl_images` i
- INNER JOIN `tbl_gallery` g
- ON g.id = i.galleryid
- WHERE g.galleryowner = ". $_SESSION['id']."")or die(mysql_error());
- $num_rows = mysql_num_rows($data);
- while($info = mysql_fetch_array( $data )) {
- echo "<div class='photo'>";
- echo "<img src='gallery/preview/". $info['imagepath']. ".jpg' alt='' />";
- echo "</div>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement