https://www.icyphoenix.com/viewtopic.php?f=26&t=5259&p=35446#p35446
-----------------------------------
DWho
Wed 07 Jan, 2009 00:20

Re: Link To Personal Sub Cat In Lang File
-----------------------------------
Hi

Well after checking and rechecking  :roll: 

I replace this part 

[code linenumbers=false]$sql = "SELECT * FROM " . ALBUM_CAT_TABLE . "
        WHERE cat_user_id = " . $userdata['user_id'];

if( !($result = $db->sql_query($sql)) )
{
    message_die(GENERAL_ERROR, 'Could not query album information', '', __LINE__, __FILE__, $sql);
}
[/code]

with this

[code linenumbers=false]$sql = "SELECT * FROM " . ALBUM_TABLE . " AS p, " . ALBUM_CAT_TABLE . " AS c
		WHERE c.cat_user_id = " . $userdata['user_id'] . "
		AND p.pic_cat_id = c.cat_id
		AND p.pic_approval = 1
		ORDER BY pic_time DESC";

if( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not query recent pics information', '', __LINE__, __FILE__, $sql);
}
[/code]

and all works good...  

thanks though I do not know why mine is different to yours  :roll: