# Mysql and php selection

**URL:** <https://forum.kirupa.com/t/mysql-and-php-selection/251152>\
**Category:** programming\
**Created:** [February 5, 2008, 8:38pm UTC](https://forum.kirupa.com/t/mysql-and-php-selection/251152 "2008-02-05T20:38:37Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![kitalpha](https://avatars.discourse-cdn.com/v4/letter/k/b77776/32.png) [@kitalpha](https://forum.kirupa.com/u/kitalpha)\
**Post date:** [February 5, 2008, 8:38pm UTC](https://forum.kirupa.com/t/mysql-and-php-selection/251152/1 "2008-02-05T20:38:37Z")

</div>

Im using slideshowpro for an image gallery. this uses a mysql database.  
i have added a page which show the last nine images added to the database using this

$query = “SELECT \* FROM ssp\_images ORDER BY modified DESC LIMIT 9”;

this then makes an xml for the images…works fine…but…  
can i filter the output?

my problem is i need to add some pics from a portrait session and a wedding but these will be password protected, is there anyway i can ignore a certain album / albums ?

the album field is “aid”

or blank any image from say album 20 or above ?

be gentle with me, it’s my first time using php/mysql 😉

thanks