[predominant]

    <table width="100%" cellspacing="0" cellpadding="5" border="0" align="center">
	  <tr>
	    <td class="bodylineblue">
                <?
                  $query = "";
                  $query = $query . "SELECT charname, petitiontext, senttime, charlevel ";
                  $query = $query . "FROM petitions ";
                  $query = $query . "ORDER BY senttime DESC ";

                  $link = mysql_connect("myDBhost", "myDBuser", "myDBpass")
                          or die("Connection Failed.");
                  mysql_select_db("eq")
                          or die("Database Unavailable.");
                  $result = mysql_query($query)
                          or die("Query failed.");

                  while ($row = mysql_fetch_object($result))
                  {
                    $senttime = getdate($row->senttime);
                    ?>
                    <table border="1" cellspacing="0" cellpadding="0" width="80%" align="center">
                      <tr>
                        <td><b>
                          <?= $senttime['mday'] ?> <?= $senttime['month'] 
?><?= $senttime['year'] ?> : </b><?= $senttime['hours'] ?>:<?= 
(strlen($senttime['minutes']) == 1 ? "0" . $senttime['minutes'] : 
$senttime['minutes']) ?>
                        </td>
                      </tr>
                      <tr>
                        <td>
                          From: <b><?= $row->charname ?></b> (lvl <?= $row->charlevel ?>)
                        </td>
                      </tr>
                      <tr>
                        <td>
                          <?= $row->petitiontext ?>
                        </td>
                      </tr>
                    </table>
                    <br/>
                    <?
                  }
                  mysql_free_result($result);

                ?>
		</td>
	  </tr>
	</table>

I am no master PHP programmer. This is my code for the petitions display at http://studentquest.newcastle.edu.au. If you find it interesting, sure, copy it - Just put a "Hacked together my Predominant" HTML comment in there