Unable to get this query going

[Marc]

8 hours already i am looking for a solution to this ** query.
I have a website that includes a minibb forum but now i wan't it to get included more.
When someone looks at the forum there is a link to the posters profile but it is not the profile i'm using for my datingsite.
What i wanna do is create a link to the members_profile.
And here is the problem.
The database stores seperate info for a users profile in two different ways.
One has a profile id and the other has member_id.
When someone posts the forum there profile_id get's set in the minibb table.
To be able to get the link working i need to have the members_id from that user instead of the profile_id.
I am trying to work around this:
what i actually need is a code that gets the poster_id from minibb_posts and compares it with the id from dt_profile to show the profile member_id from dt_profile.
advice?

       $fMember = "select 'poster_id' from 'minibb_posts' where poster_id='$poster_id'";
      $query1 = "select 'id' FROM 'dt_profile' WHERE id == '$poster_id'";
      $queryt1 = mysql_query($query1);
      $result1 = mysql_result($queryt1);
$viewReg="<a href=\"../../index.php?page=view_profile&id={$result1}\">$ins</a>";[code=php] 

[bastien]

select d.id from dt_profile d, minibb_posts m where
m.poster_id = d.id and m.poster_id ='$poster_id'";

[Marc]

Thanks, but no luck :-(
I changed the code to

$sql = "select d.id from dt_profile d, minibb_posts m where m.poster_id = d.id and m.poster_id ='$poster_id'";
$viewReg="<a href=\"../../index.php?page=view_profile&id={$query}\">$ins</a>";  

At this point it shows a profile but it's always my own profile instead of the posters profile