www.webdeveloper.com
Results 1 to 2 of 2

Thread: Need help getting photos in array and display in loop, returning none now

  1. #1
    Join Date
    May 2006
    Posts
    22

    Exclamation Need help getting photos in array and display in loop, returning none now

    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);&amp;userid=88" id="upload-photos-button">Start Uploading</button></div>
    	<?php
    	}
    	?>
    </div>

  2. #2
    Join Date
    May 2006
    Posts
    22

    Exclamation Got the query to run correct, but still not retunign the rows of photos

    I fixed the $query to return the correct row when I run it in MySQL directly in the database but on php code , here is the error I am getting now..

    Code:
    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\xxx\photos.album.php on line 126

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles