I am trying to return all the photos in the database that has the albumid associated with that table info. I can echo the $album->id (albumid) no problem, but my query it think is somewhat off. Please anyone.
[code]
<div id=”photo-items” class=”photo-list-item”>
<?php
echo $album->id.'<br>’;
// fetch album photos and ids
$database =& JFactory::getDBO();
$query = “SELECT * FROM jos_photos where albumid = “.$album->id.” ORDER BY ASC”;
$photos = mysql_query($query); //This returns and array of photos, but then needs to display all the photos in loop below, but it not retuning none, even if there is 100 photos in table and in the folder directory
if($photos)
{
for( $i=0; $i<count($photos); $i++ ){
$row =& $photos[$i];
?>
<div class=”photo-item” id=”photo-<?php echo $i;?>” title=”<?php echo $this->escape($row->caption);?>”>
<a href=”<?php echo $row->link;?>”><img class=”” src=”<?php echo $row->getThumbURI();?>” alt=”<?php echo $this->escape($row->caption);?>” id=”photoid-<?php echo $row->id;?>” /></a>
<?php
if( $isOwner )
{
?>
<div class=”photo-action”>
<a href=”javascript:void(0);(‘<?php echo $row->id;?>’);” class=”remove”><?php echo JText::_(‘CC REMOVE’);?></a>
</div>
<?php
}
?>
</div>
<?php
}
}
else
{
?>
<div class=”empty-list”><?php echo JText::_(‘CC NO PHOTOS UPLOADED YET’);?> <button class=”button button-upload” href=”javascript: void(0);&userid=88″ id=”upload-photos-button”>Start Uploading</button></div>
<?php
}
?>
</div>