https://www.icyphoenix.com/viewtopic.php?f=26&t=1375&p=10905#p10905
-----------------------------------
Mighty Gorgon
Tue 27 Mar, 2007 01:23

Re: Mouseover Of Thumbnail In Forum
-----------------------------------
The SQL part it is easy... what is difficult is to integrate it through BBCodes... :wink:

[code]$sql = "SELECT p.*, c.*
		FROM ". ALBUM_TABLE ." AS p, ". ALBUM_CAT_TABLE ." AS c
		WHERE p.pic_id = '$pic_id'
			AND c.cat_id = p.pic_cat_id";

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

$thispic = $db->sql_fetchrow($result);

$cat_id = $thispic['pic_cat_id'];
$album_user_id = $thispic['cat_user_id'];
$pic_filename = $thispic['pic_filename'];
$pic_title = $thispic['pic_title'];[/code]

Once you have the pic_id and these vars you may easily add them into the BBCode generated code...

If you have Icy Phoenix I can try to show you an easy way to integrate it into BBCodes.