Sample> Db Showrecords Breaker

<?php

// include TPLN
include('TPLN/TPLN.php');

$TPLN = new TPLN;
$TPLN->open('Db_showrecords_breaker.html');

$TPLN->dbConnect();
$sql = "SELECT
                Country.*,
                CountryLanguage.Language AS breaker  -- obligatory name is breaker
        FROM
                Country,
                CountryLanguage
        WHERE
                CountryLanguage.CountryCode = Country.Code
        ORDER BY
                breaker";

$TPLN->setUrl('?'); // optional take current page by default
$TPLN->showRecords($sql, 10);

$TPLN->dbClose();
$TPLN->write();

?>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Db showrecords breaker !</title>
    <link href="../style.css" rel="stylesheet" type="text/css" />
</head>

<body>

<table cellpadding="3" cellspacing="1">
<bloc::data>

    <bloc::loop>

    <!-- breaker -->
    <bloc::breaker>
    <tr>
        <th colspan="4">{breaker}</th>
    </tr>
    </bloc::breaker>
    <!-- breaker -->

    <tr bgcolor="{_NavColor}">
        <td align="right">{_Id}.</td>
        <td>{Continent}</td>
        <td>{Region}</td>
        <td>{Name}</td>
    </tr>
    </bloc::loop>

    <tr>
        <th colspan="4">
            <bloc::previous>
                <a href="{_Url}"><img src="../previous.gif" align="absmiddle" /></a>            </bloc::previous>

            Page {_PageNumber} / {_PageCount}

            <bloc::next>
                <a href="{_Url}"><img src="../next.gif" align="absmiddle" /></a>            </bloc::next>
        </th>
    </tr>
    </table>

<bloc::norecord>No record found</bloc::norecord>


</bloc::data>
</body>

<br>
<br>
{_Logo}<font size="1"> in {_Chrono} s<br>
Queries executed: {_QueryCount}</font>

</body>
</html>