[SOLVED] Newbie Need Basic Help With Some PHP Mysql Code

[Looktrne]

I have a code on my website that displays some options for user profile

 

it creates a link for the member to view there profile...

 

problem is it creates a link to the member ID rather than the profile ID so it displays the wrong profile

 

I need it to grab from the dt_profile              id field rather than the member_id field

 

Please have a look and tell me how to modify this code if you could..

 

 

$fMemberProfile = f(q("SELECT status FROM dt_profile WHERE member_id='$fMember[id]'"));

 

 

// Setup links:

 

$call_image = '<img src="images/item.gif" width="16" height="16">';

$lb = "<a href=index.php";

$le = "</a>";

 

 

$prev_profile_lb = "$call_image$lb?page=view_profile&id=$fMember[id]>";

$prev_profile_le = $le;

 

 

 

the variable $fMember[id] ends up as the member_id  from dt_profile  it needs to come back as the id

 

if anyone can help please advise... I am very new at this

 

but not completly numb

 

Paul

[Looktrne]

I solved it

 

 

 

Paul

[newbaby]

Can you please tell me what you did to fix?

 

Thanks