Hit a dead end...

...and i need some direction please

I've created a new table - let's call it 'mark'

there're four field within it:

id
category
description
image

If I wanted to call the values of these fields into a vB template, what exactly would I need to do?

I thought I would be able to just do something like:

PHP Code:

$DB_site->query("SELECT image,description FROM mark WHERE id=$id"); 

and then use codes such as $image or $mark[image], but I'm assuming that's not right, cos it just comes out blank

I imagine I may need to edit functions.php or global.php, but as has been demonstrated by my stoopid questions in the past, I'm not that bright when it comes to PHP

Any assistance would be appreciated

PS - anyone else think a 'Creating Hacks For vBulletin' tutorial would be welcomed by thousands?

[Lesane]

Originally posted by MarkB
PS - anyone else think a 'Creating Hacks For vBulletin' tutorial would be welcomed by thousands?

100% Yes

[Admin]

$mark=$DB_site->query_first("SELECT image,description FROM mark WHERE id=$id");

Then you'll be able to use $mark[image] etc.

[MarkB]

Thanks Firefly, yet again I really appreciate your help