PHP tng_num_rows Examples

Example #1

File: index.php Project: seta-hungnh/test

                                <h2 class="art-postheader"><?php 
echo getTemplateMessage('t9_welcome');
?>
</h2>
                <div class="cleared"></div>
                                <div class="art-postcontent">

<img src="<?php 
echo $cms['tngpath'] . $templatepath . $tmp['t9_mainimage'];
?>
" alt="" style="float:left;" class="temppreview" />
<?php 
if ($chooselang) {
    $query = "SELECT languageID, display, folder FROM {$languages_table} ORDER BY display";
    $result = tng_query($query);
    $numlangs = tng_num_rows($result);
    if ($numlangs > 1) {
        echo getFORM("savelanguage2", "get", "tngmenu3", "");
        echo "<select name=\"newlanguage3\" id=\"newlanguage3\" style=\"font-size:11px;\" onchange=\"document.tngmenu3.submit();\">";
        while ($row = tng_fetch_assoc($result)) {
            echo "<option value=\"{$row['languageID']}\"";
            if ($languages_path . $row['folder'] == $mylanguage) {
                echo " selected=\"selected\"";
            }
            echo ">{$row['display']}</option>\n";
        }
        echo "</select>\n";
        echo "<input type=\"hidden\" name=\"instance\" value=\"3\" /></form>\n";
    }
    tng_free_result($result);
}

Example #2

File: index.php Project: seta-hungnh/test

					<table width="200" border="0" cellspacing="0" cellpadding="0">
						<tr>
													<td valign="top"><span class="emphasis"><?php 
echo $text['latupdates'];
?>
</span></td>
												</tr>
		<tr>
				<td colspan="4" class="line"></td>		</tr>
												<tr><td><span class="smallest">&nbsp;</span></td></tr>
												<tr><td valign="top">
							<div class="normal">
					<?php 
$tngquery = "SELECT lastname, firstname, changedate, personID, gedcom, living, private, branch, lnprefix, title, suffix, prefix FROM {$people_table} ORDER BY changedate DESC LIMIT 10";
$resulttng = tng_query($tngquery) or die($text['cannotexecutequery'] . ": {$tngquery}");
$found = tng_num_rows($resulttng);
while ($dbrow = tng_fetch_assoc($resulttng)) {
    $lastadd .= "<a href=\"getperson.php?personID={$dbrow['personID']}&amp;tree={$dbrow['gedcom']}\">";
    $dbrights = determineLivingPrivateRights($dbrow);
    $dbrow['allow_living'] = $dbrights['living'];
    $dbrow['allow_private'] = $dbrights['private'];
    $lastadd .= getNameRev($dbrow);
    $lastadd .= "</a><br />\n";
}
tng_free_result($resulttng);
echo $lastadd;
?>
							
							</div> <!-- end of normal div -->
						</td></tr>
												<tr><td valign="top"><span class="normal">&nbsp;</span></td></tr>