Stepping through a mysql database

[BeyRevRa]

I need to find a way to get this to work in vbulletin. I'm working with a friend of mine on his site, and he needs a section added, that will list the top 10 of certain things, as well as a full list of some other data. normally, all I have to do is something like

$msResult=mysql_query("select * from my_table order by created desc;");
while($msData=mysql_fetch_array($msResult))
{ echo $msData['created'] . "<br>";
}

and it will echo out all the data in a nice (ugly) list.

I'm trying to do this in a vbulletin template, and any code that escapes into php gets ignored. I tried to create two templates, and print out one template, perform my code in the php file itself, and print out another template, but it would neve print the second template. what is the best way to add your own code to step through a database, but still keep it in the template format that all the other pages use?

[assassingod]

For vB2

PHP Code:

  $msResult = $DB_site->query("
  SELECT *
  FROM my_table
  ORDER BY created DESC
  ");
  while($msData = $DB_site->fetch_array($msResult))
  {
  eval("\$variable .= \"".gettemplate('templatename')."\";");
  } 


Create 'templatename' template with the $msData variables inside, then use $variable in a template of your choice

For vB3:

PHP Code:

  $msResult = $DB_site->query("
  SELECT *
  FROM my_table
  ORDER BY created DESC
  ");
  while($msData = $DB_site->fetch_array($msResult))
  {
  eval('$variable .= "' . fetch_template('templatename') . '";');
  } 


Same applies for this.

[BeyRevRa]

thanks man, works like a charm, don't know why I didn't think of that earlier.