how to add "Serial Number" PHP Code here with repeat region,?

S

Sohail

New member
<?php
mysql_select_db($database_NConn, $NConn);
$query_rsAchievements = "SELECT * FROM studies_achievement WHERE cat = '1' ORDER BY dataId DESC";
$rsAchievements = mysql_query($query_rsAchievements, $NConn) or die(mysql_error());
$row_rsAchievements = mysql_fetch_assoc($rsAchievements);
$totalRows_rsAchievements = mysql_num_rows($rsAchievements);
?>
<table width="100%" cellspacing="0;" class="sortable">
<thead>
<tr><th width="82" class="Headingss">S No.</th>
<th width="567" class="Headingss">Title</th>
<th width="273" class="Headingss">Author</th>
<th width="156" class="Headingss">Year</th>
</tr>
</thead>
<tbody><? for ($rows=0;$rows<$totalRows_rsAchievements;$rows++) {?>
<tr>
<td class="copyright">Here i need Serial Numer repeate region code </td>
<td class="copyright"><a href="islamabadPaper_Detail.php?dataId=<? echo mysql_result($rsAchievements,$rows,'dataId')?>"><? echo mysql_result($rsAchievements,$rows,'title')?></a><a href="islamabadPaper_Detail.php?dataId=<? echo mysql_result($rsAchievements,$rows,'dataId')?>"></a></td>
<td class="copyright"><a href="islamabadPaper_Detail.php?dataId=<? echo mysql_result($rsAchievements,$rows,'dataId')?>"><? echo mysql_result($rsAchievements,$rows,'author')?></a><a href="islamabadPaper_Detail.php?dataId=<? echo mysql_result($rsAchievements,$rows,'dataId')?>"></a></td>
<td class="copyright"><a href="islamabadPaper_Detail.php?dataId=<? echo mysql_result($rsAchievements,$rows,'dataId')?>"><? echo mysql_result($rsAchievements,$rows,'year')?></a></td>
</tr>
<? } ?>
 
Back
Top