obtain the list/array of url of an album

i want to obtain the list of urls of an album to use with a flash slide show
i have try to use the rss but it's difficult to extract the url
i suppose it'more easy to make a mysql query but i dont know how to do write it.