Getting from plugin to forumhome .. ?

[steadicamop]

I'm a little lost, it's so much different to what I'm used to, here is the code I have (it is messy but this meant it worked)

PHP Code:

$result = mysql_query("SELECT vbfclassifieds_ads.title, vbfclassifieds_ads.userid, vbfclassifieds_ads.id, user.userid, user.username FROM vbfclassifieds_ads LEFT JOIN user ON vbfclassifieds_ads.userid = user.userid LIMIT 5");

?><table border='0'>
<tr>
<th>Title</th>
<th>Username</th>
</tr>
<?php
while($row = mysql_fetch_array($result))
  {
  ?>
<tr>
<td><a href=vbfclassifieds.php?do=showad&adid=<?php echo $row['id']; ?>><?php echo $row['title']; ?></a></td>  <td><a href=/member.php?u=<?php echo $row['userid']; ?>><?php echo $row['username']; ?></a></td>
</tr> <?php
  }

How would I go around removing the table stuff and turning them into variables - then how do I use the while to just show 5 lines within that template?