calling mysql fields into a .php webpage
 

Hey guys,
I currently am customizing my forum a fair bit.
And i have got stuck on this problem.

Situation:
I have created a .php document that displays a youtube video and it works fine.

What I want:
I want this .php document to display a users youtube video, so i need to get the field from the database and make it so the .php document can call it and use the link from it to display the video.

The server is called: 'localhost'
The database is called 'db_vbulletin'
The table is called 'userfield'
The field is called 'field39'

But saying this, the youtube video link will be different between users, so im not sure what kind of factor that would have.

If i am posting in the wrong place or there is a better forum, please direct me.
Thanks.

Murty

Bump

Bump

Hi murty, If the youtube url is stored in a custom profile field within vbulletin, you should just be able to call the url with $vbulletin->userinfo['field39'] in your template as the url like:

<a href="$vbulletin->userinfo['field39']>youtube link</a>

Thanks for the reply antivirus.
But i just tried your idea, and it comes up with this first:

When i click on that, it comes up with this:

Any ideas?

If you're using this in a template:
If you're using this in Plugins:

Yeah, but im not using a plugin. I'm using a .php file in the forum root.

If you've included global.php then the Plugin code I posted above should work.

What do you mean, 'included global.php'?

hmm, not sure how this is meant to work, but it hasnt so...

Bump