need help about function

[MyPornLife.info]

plz look at these 3 types of code

type 1:

PHP Code:

$query = $vbulletin->db->query_first("SELECT * FROM " . TABLE_PREFIX . "table");

function abc($var)
{
echo $query[$var];
} 


type 2:

PHP Code:

function abc($var)
{
global $vbulletin;
$query = $vbulletin->db->query_first_slave("SELECT * FROM " . TABLE_PREFIX . "table");
echo $query[$var];
} 


type 3:

PHP Code:

$query = $vbulletin->db->query_first("SELECT * FROM " . TABLE_PREFIX . "table");

function abc($var)
{
global $query;
echo $query[$var];
} 


i tried all 3 of those....type 1 didn't work. type 2 & 3 work

but i dont want to use type 2....coz everytime i use that function it will connect to DB & waste a lot of resource. if i use this function 10 times in a page, it will connect to DB 10 times....too bad!

but not sure about type 3....what about it? is it waste resource like type 2 ??


help me plz