include a sql query into a template

[bambam]

hi,

can someone tell me how to include a sql query into a template?
i want my users to be able to see their invitekeys.

the invitekey is stored in a table which looks like:

id inviter     invited            code          sent          accepted         done
1     22     [email protected]      23423412      18.01.2014          0              0
2     13     [email protected]      23453412      20.01.2014          1              0

my goal is that i have a link for my users where they can see their invitations, including invitecode and wether the invited user registered already.(not the invitation-details from other users)
and my prob is that i´m pretty new to vb and i don´t know how to realize it

someone can help? or give me an explanation or links to tutorials?

thanks in advance

Bambam

 

[Ozzy47]

What is your programming experience with PHP and HTML?

 

[bambam]

What is your programming experience with PHP and HTML?

not much. i´m able to make a sql query and show the result via html.
but i have never done sth like this in vbulletin.

especially that a user can only see his invites is my problem, i thought about sth like it is in "own threads":

search.php?do=finduser&userid=[COLOR="#FF0000"]{bbuserinfo.userid}[/COLOR]&starteronly=1&contenttype=vBForum_Thread

maybe it is possible to do some copy and paste from search.php to a file called invites.php where just the sql query differs?
but i think i´m too unexperienced in this and therefore i started this thread here

 

[bambam]

anyone willing to help me a bit?