Show custom profile field on page.

[RLShare]

ahh just seen you edited your post... I forgot to mention that you will also need to change the field6 in the 2 spots that this shows up....'$field['field6']'

[soundboy]

yup i changed that
its working but i wish to show it on my vbdrupal page? also its showing empty fields, how can i make it only show ones that are filled in?

[RLShare]

change the query to this but edit the field numbers again

PHP Code:

 "SELECT field6
FROM ".TABLE_PREFIX."userfield
WHERE field6 != ''
ORDER BY rand( )
LIMIT 10 " 


As far as the VBDrupal page, I have never messed with drupal before.

[soundboy]

Thankyou VERY much!
I changed the hook to global_start
+rep

--------------- Added [DATE]1216358345[/DATE] at [TIME]1216358345[/TIME] ---------------

oh.. sorry again.. but i have another field i want to display..

Ive set up the url which is field7, and i wish to display field5 like..

<a href="field7">field5</a>

Thanks for your help again!

[RLShare]

Change the query to

PHP Code:

"SELECT field5, field7
FROM ".TABLE_PREFIX."userfield
WHERE field5 != '' AND field7 !=''
ORDER BY rand( )
LIMIT 10" 


And then change this part of the plug-in...

<a href=\''.$field['field6'].'\'>'.$field['field6'].'</a>

To..

<a href=\''.$field['field7'].'\'>'.$field['field5'].'</a>

[soundboy]

many thanks mate