HIDE DOTTET LINE

**frizzle** · Jan 2 '06, 08:05 PM

Re: HIDE DOTTET LINE

mathijs rooda wrote:[color=blue]
> 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_newsle ft = 8;
> $pageNum_newsle ft = 0;
> if (isset($_GET['pageNum_newsle ft'])) {
> $pageNum_newsle ft = $_GET['pageNum_newsle ft'];
> }
> $startRow_newsl eft = $pageNum_newsle ft * $maxRows_newsle ft;
>
> mysql_select_db ($database_clan , $clan);
> $query_newsleft = "SELECT * FROM news ORDER BY datesubmit DESC";
> $query_limit_ne wsleft = sprintf("%s LIMIT %d, %d", $query_newsleft ,
> $startRow_newsl eft, $maxRows_newsle ft);
> $newsleft = mysql_query($qu ery_limit_newsl eft, $clan) or die(mysql_error ());
> $row_newsleft = mysql_fetch_ass oc($newsleft);
>
> if (isset($_GET['totalRows_news left'])) {
> $totalRows_news left = $_GET['totalRows_news left'];
> } else {
> $all_newsleft = mysql_query($qu ery_newsleft);
> $totalRows_news left = mysql_num_rows( $all_newsleft);
> }
> $totalPages_new sleft = ceil($totalRows _newsleft/$maxRows_newsle ft)-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"><d iv 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><?p hp echo $tekst ?></strong></a></td>
> </tr>
> </table>
> <table width="215" border="0" align="center" cellpadding="0"
> cellspacing="0" >
> <tr>
> <td width="15" class="news">&n bsp;</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"><di v 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_ass oc($newsleft)); ?>
> <?php
> mysql_free_resu lt($newsleft);
> ?>[/color]

You *could* do the following:
Count the number of results from your database. (8 in your example)
Create a new variable:

+++++++++++++++ +++++++++++++++ +++++++++++++++ +++++++++

++$outputted_he adlines = 0;

do{

++$outputted_he adlines;

if( ++$outputted_he adlines < $number_of_retu rned_results )
{
$print_dots = true;
}
else
{
$print_dots = false;
};

// do all your own stuff
// and in the dotted line part, do this:

?>
<table width="215" border="0" align="center" cellpadding="0"
cellspacing="0" >
<tr>
<td width="761"><di v align="center"> <?php

if( $print_dots === true ){ echo '<div align="center"> <img
src="./gifs/pic_57.gif"
width="212" height="3"></div>' };

?></div></td>
</tr>
</table>
<?php

}while

+++++++++++++++ +++++++++++++++ +++++++++++++++ +++++++++

Of course, the $number_of_retu rned_results variable corresponds with
the number
of results that are returned from your query.

Hope to've helped a fellow dutch bloke

Frizzle.

HIDE DOTTET LINE

HIDE DOTTET LINE

Comment