lol, you have to put:
$variable['id'], $variable['name'], $variable['url'], $variable['description'] in your template (site_test). $variable['id'] would display the mysql field id as do the other variables have the sam operation.

and with the query you need to change tablename to your mysql table name. ANd change 1 to a valid mysql field (i think this would be id, name, description, or url).

I get this error when I save the templeat:
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/rdsx667/public_html/forum/includes/adminfunctions_template.php(3537) : eval()'d code on line 18

Just to let you know. it's extremly hard for peole to help you if you don't post the code you're using when you list errors. When asking for help try to list the error and your code.

Remove the ' from the variables when putting them in vbulletin templates.

sorry about this I'll try removing ' from it though.
It works with this thank you for the help.

on more question and I'm done how do I make the code repeat for the resaults?

you mean print the results for each row in the table?

yes, help much apprictated

Replace 'tablenamehere' with the name of the table which has the rows you want to print out. Replace 'templatenamehere' with the name of the template you want printed for every row in that table. Obviously you have to create a new template (templatenamehere). This template will be printed to the browser (eval'd) over and over again for each row in the table (tablenamehere). In the template you put your html and variables you want displayed for each row.

thanks for the help it is much apprcated.

No prob, glad to help.