Profile Fields + User Details SQL

[barryhand]

Hi,

I have additional profile fields which i want displayed on a specific page along with some of the users information

I only want data returned where information has been entered.

I want

Username(link to profile) | Profilefield value

Simple query.

Thanks

[afullcup]

I'm rather new to this, so I may be way off base here, but here is code I added to the postbit template to display something on every post if a user entered information into a custom field on their profile page.

PHP Code:

<if condition="$post['field5']"><div>$vbphrase[turned_20_into]$post[field5]</div></if> 

hth, and sorry if it doesn't

[barryhand]

I'm looking for the actual SQL as I'm using a custom pages hack