What's the problem with querys in Vbulletin Pages !

[Creative Suite]

Hi all

at first i wanna to apologize for my english If any one will not understand me

Secondly i have an query , i'm using it to get banners from datebase

PHP Code:

$doquery = $DB_site->query("select * from " . TABLE_PREFIX . "adv where main ='1' order by 'id' desc ");
while($row=$DB_site->fetch_array($doquery)){
 
eval('$show = "' . fetch_template('adv_creativeSuite') . '";');
 
 
} 


adv_creativeSuit template

<a href='$row[url]' target='_blank'><img border='0' src='$row[image]' alt='$row[name]'></a>

in vbulletin pages , it's give me just one row ! , In spite of i have more than one !

but win i use it in external php file , it's give me all rows


comment*: all querys give me the same problem in vbulletin pages

at last i hope that any one understand what did i mean , and give me the solution :ermm:


thank you