Album name?

[matiseijas]

Hello, is there a PHP variable that gives me the name of the album the pic belongs to?

[Nibbler]

I dont know if this already exists, but it's quite a simple function to make:

Code Select Expand


function which_album($pid)
{
global $CONFIG;
$result = db_query ("SELECT a.title as title FROM {$CONFIG['TABLE_ALBUMS']} as a,{$CONFIG['TABLE_PICTURES']} as p WHERE p.pid = $pid AND a.aid = p.aid");
$row = mysql_fetch_array($result);
return $row['title'];
}


[weegee]

Works wonderful! Thanks!