Help with Php/mysql for image hosting frontpage.

[calumj49]

<div id="recent">
					<p class="title"><?php echo "Staff Picks"; ?></p>
					<div id="gallery">
						<?php $i = 0; while($album = mysql_fetch_row($recent)): ?>
						<?php if(++$i%4 == 1): ?><div><?php endif; ?>
						<?php $image = mysql_fetch_row(mysql_query('SELECT `id`, `extension` FROM `image` WHERE `album_id`='.$album[0].' ORDER BY `id` DESC LIMIT 0,1')); ?>
						<a href="<?php echo WEB; ?>a/<?php echo alphaID($album[0]); ?>">
							<img src="<?php echo WEB; ?>small/<?php echo alphaID($image[0]); ?>.<?php echo $image[1]; ?>" alt=""/>
						</a>
						<?php if($i%4 == 0): ?></div><?php endif; ?>
						<?php endwhile; ?>
						<?php if($i%4 != 0): ?></div><?php endif; ?>
					</div>

 

I have this code, which on my image hosting website, displays a grid of the latest albums of images that users upload. I really have no experience in Php.

 

I to change this code to simply display a grid of albums that i choose, not the latest. Like 'staff picks' instead of 'most recent'.

 

 

Any help would be greatly appreciated.

[WatsonN]

How are staff picks determined? Is there a table just for it or a column in your existing table for it or what?

 

EDIT: adding missing information.