Mysql Queries

[bkbelew]

Ok, i have pretty much the same thing as him, im having problems figuring out how to parse the thread contents itself though, heres what i have.. modified w/out the file calls from vb. I want to be able to parse the username, title, and content of the post. But I cant figured out how to do it, any help would be greatly appreciated

PHP Code:

<?

  $dbUser = "fdsfdsfdsfsd";
  $dbPasswd = "794321y";
  $dbServer = "localhost";
  $dbPort = "3306";
  $dbDatabase = "fsdfdsfdsfdsf";

  $link = mysql_connect("$dbServer:$dbPort", $dbUser, $dbPasswd);

  if (!$link) {
    // there was a problem connecting
    die("Could not connect to database:" . mysql_error());
  }

  $rc = mysql_select_db($dbDatabase, $link);

  if (!rc) {
    // problem selecting database
    die("Could not select database:" . mysql_error());
  }

  $query = ("SELECT * FROM "  . "thread AS thread WHERE thread.forumid = 2 ORDER BY dateline DESC LIMIT 10");

  $result = mysql_query($query, $link);

  if (!$result) {
    // there was a problem executing the query
    die("Could not execute query:" . mysql_error());
  }

  while ($row = mysql_fetch_array($result)) {
    ?>

    Title: <? echo $row[title]; ?> <br> User: <? echo $row[postusername]; ?><br> <br />

    <?
  }

  mysql_close($link);

?>