|
Posted by mathijs rooda on 01/02/06 21:00
Hello,
I hope someone can help me.
I have a script that shows the last 8 rows of a recordset. the rows a
seperated by a dottet line that is a gif in the repeat region. look at
picture http://www.gameology.de/naamloos.gif
my problem is that i dont want to show the last dottet line on the last row
of the record. see arrow at picture.
any knows how to do that??
Code :
<?php
$maxRows_newsleft = 8;
$pageNum_newsleft = 0;
if (isset($_GET['pageNum_newsleft'])) {
$pageNum_newsleft = $_GET['pageNum_newsleft'];
}
$startRow_newsleft = $pageNum_newsleft * $maxRows_newsleft;
mysql_select_db($database_clan, $clan);
$query_newsleft = "SELECT * FROM news ORDER BY datesubmit DESC";
$query_limit_newsleft = sprintf("%s LIMIT %d, %d", $query_newsleft,
$startRow_newsleft, $maxRows_newsleft);
$newsleft = mysql_query($query_limit_newsleft, $clan) or die(mysql_error());
$row_newsleft = mysql_fetch_assoc($newsleft);
if (isset($_GET['totalRows_newsleft'])) {
$totalRows_newsleft = $_GET['totalRows_newsleft'];
} else {
$all_newsleft = mysql_query($query_newsleft);
$totalRows_newsleft = mysql_num_rows($all_newsleft);
}
$totalPages_newsleft = ceil($totalRows_newsleft/$maxRows_newsleft)-1;
?>
<?php
// for changing colors in background
//$kleur1 ="./gifs/try33-2_29.gif";
//$kleur2 ="./gifs/try33-2_32.gif";
//$kleur = ($i++ % 2) ? "$kleur1" : "$kleur2"; //aanpassen in config
?>
<?php do {
$tekst = substr(Maakop($row_newsleft['title']),0,25);?>
<table <?php //echo "background=\"$kleur\""; ?> width="215" height="29"
border="0" align="center" cellpadding="0" cellspacing="0">
<td><table width="215" border="0" align="center" cellpadding="0"
cellspacing="0">
<tr>
<td width="15" class="news"><div align="center"><img
src="./gifs/pic_49.gif" width="8" height="8"></div></td>
<td width="200" height="15" class="news"><a
href="index.php?page=newsshow&id=<?php echo $row_newsleft['id'];
?>"><strong><?php echo $tekst ?></strong></a></td>
</tr>
</table>
<table width="215" border="0" align="center" cellpadding="0"
cellspacing="0">
<tr>
<td width="15" class="news"> </td>
<td width="200" class="scene"><?php echo
$row_newsleft['datesubmit']; ?> - <?php echo $row_newsleft['clanname'];
?></td>
</tr>
</table></td>
</tr>
</table>
<table width="215" border="0" align="center" cellpadding="0"
cellspacing="0">
<tr>
<td width="761"><div align="center"><img src="./gifs/pic_57.gif"
width="212" height="3"></div></td> (SHOWS DOTTET LINE)
</tr>
</table>
<?php }} while ($row_newsleft = mysql_fetch_assoc($newsleft)); ?>
<?php
mysql_free_result($newsleft);
?>
Navigation:
[Reply to this message]
|