Plugin: NextGEN Gallery – Menu List for Gallery Images

Last month, twobadfish posted a brilliant solution for listing gallery names as links to create a text-based menu for NextGEN.

http://wordpress.org/support/topic/285556?replies=12

I’m trying to use this as a base to list the $image->alttext (the image titles) within a specific gallery instead of just listing the galleries. Any ideas?

Here is the working code from twobadfish:

<?php
	$galleries = array();
	$query = "SELECT * FROM wp_ngg_gallery WHERE gid";
        $result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
	$galleries[] = $row['title'];
}
	$i = 1;
	foreach ($galleries as &$value) {
		echo '<a href="/?page_id=61&album=1&gallery='.$i.'">'.$value.'</a>';
		$i++;
	}
?>