Menu
probley an easy one, but I can see the problem for looking. for some reason this code keeps looping and never stops displaying the same and only record over and over
[code]
$album_owner = ‘0000010’;
$get_album = (“SELECT album_name, album_cover, album_create_date, image_count, album_id FROM albums WHERE album_owner = ‘$album_owner'”);
$album = mysql_query($get_album )or die(“SQL Error: $get_album <br>” . mysql_error());
?>
<?php while($albums = mysql_fetch_assoc($album)){
$folder_name = $albums[‘album_name’].’-‘.$albums[‘album_id’];
$album_id = $albums[‘album_id’];
$album = mysql_query($get_album)or die(“SQL Error: $get_album_cover <br>” . mysql_error());
//Get Album Cover
$get_album_cover = (“SELECT album_id, photo_name FROM photos WHERE album_id = ‘$album_id'”);
$album_cover = mysql_query($get_album_cover)or die(“SQL Error: $get_album_cover <br>” . mysql_error());
$cover = mysql_fetch_assoc($album_cover);
?>
<div style=”width:210px; height:210px; float:left;”>
<img src=”gallery/<?php echo $folder_name; ?>/thumbs/th_<?php echo $cover[‘photo_name’]; ?>” width=”200″ height=”133″>
<dl class=”gallery”>
<dt class=”gallery”>Album Name:</dt> <dd><?php echo $albums[‘album_name’]; ?></dd>
<dt class=”gallery”>Photo Account:</dt> <dd>10</dd>
<dt class=”gallery”>Album Views:</dt> <dd>69</dd>
</dl>
</div>
<? } ?>