Formatting MySQL Results

Dev Articles Community Forums Sponsor:

July 9th, 2003, 08:27 PM

mg03

Junior Member

Join Date: Jul 2003

Posts: 7

Time spent in forums: < 1 sec
Reputation Power: 0

Formatting MySQL Results

I currently have a page that displays the content of one of my databases. I would like to insert a <HR> after every 5 entries. How would I go about doing this? My current code:

PHP Code:


		
			
<?

// grab the users from the database and throw them in a table

$conf_v02 = mysql_query("SELECT * FROM users");

$numrows  = mysql_numrows($conf_v02);



WHILE ($disp_v01 = mysql_fetch_array($conf_v02)) {

    $bgcolor = (++$i & 1) ? '#4B8FFF' : '#1F73FF';

    $txclass = (++$j & 1) ? 'style2'  : 'style4' ;

?>

<TR>

<TD WIDTH="14%" BGCOLOR="<?=$bgcolor;?>"><P ALIGN="center" CLASS="<?=$txclass;?>">PAGE # SHOULD GO HERE</TD>

<TD WIDTH="14%" BGCOLOR="<?=$bgcolor;?>"><P ALIGN="center" CLASS="<?=$txclass;?>" STYLE="margin-top: 3; margin-bottom: 3;"><? echo $disp_v01['id']; ?></TD>

<TD WIDTH="14%" BGCOLOR="<?=$bgcolor;?>"><P ALIGN="center" CLASS="<?=$txclass;?>"><? echo $disp_v01['name_f']; ?></TD>

<TD WIDTH="14%" BGCOLOR="<?=$bgcolor;?>"><P ALIGN="center" CLASS="<?=$txclass;?>"><? echo $disp_v01['name_l']; ?></TD>

<TD WIDTH="14%" BGCOLOR="<?=$bgcolor;?>"><P ALIGN="center" CLASS="<?=$txclass;?>"><? echo $disp_v01['name_u']; ?></TD>

<TD WIDTH="14%" BGCOLOR="<?=$bgcolor;?>"><P ALIGN="center" CLASS="<?=$txclass;?>"><? if ($disp_v01['seclvl'] == '2') { $thelvl = 'Admin'; } elseif ($disp_v01['seclvl'] == '1') { $thelvl = 'Moderator'; } else { $thelvl='Basic'; } ?><?=$thelvl; ?></TD>

<TD WIDTH="14%" BGCOLOR="<?=$bgcolor;?>"><P ALIGN="center" CLASS="<?=$txclass;?>"><? if ($disp_v01['locked'] == '1') { $islocked='Yes'; } else { $islocked='No'; } ?><?=$islocked;?></TD>

</TR>

<?

}

// end loop

?>

Last edited by mg03 : July 9th, 2003 at 08:34 PM.

July 9th, 2003, 09:02 PM

avit

Not Yet Perfect

Join Date: Nov 2002

Location: Squamish, BC

Posts: 111

Time spent in forums: < 1 sec
Reputation Power: 7

PHP Code:


		
			
// enter loop...



// do stuff...



if (++$rowcount % 5 == 0 && $rowcount < $numrows - 1) {

  echo '<tr><td colspan="7"><hr/></td></tr>';

}



// end loop

Last edited by avit : July 9th, 2003 at 09:10 PM.

July 9th, 2003, 09:41 PM

mg03

Junior Member

Join Date: Jul 2003

Posts: 7

Time spent in forums: < 1 sec
Reputation Power: 0

Thankyou, but unfortunately it echos a <HR> after the first 2 rows for some reason. After that, it functions correctly and places them every 5 rows. Do you have a clue why?

July 9th, 2003, 10:46 PM

avit

Not Yet Perfect

Join Date: Nov 2002

Location: Squamish, BC

Posts: 111

Time spent in forums: < 1 sec
Reputation Power: 7

I had an off-by-one error in my original code; the $numrows - 1 wasn't necessary so change it to just $numrows (see code sample below).

However, that doesn't solve your problem. I can't really say what's wrong without seeing it in place in your code. You don't have another existing variable called $rowcount do you?

Try running this stand-alone and see that it works:

PHP Code:


		
			
<pre>

<?php

$numrows = 51;

for ($i = 1 ; $i <= $numrows ; $i++) {

  echo "row $i counted as $rowcount\n";

  if (++$rowcount % 5 == 0 && $rowcount < $numrows) {

    echo "------------------------ $rowcount \n";

  }

}

?>

</pre>

July 9th, 2003, 11:52 PM

mg03

Junior Member

Join Date: Jul 2003

Posts: 7

Time spent in forums: < 1 sec
Reputation Power: 0

Thanks a lot avit. That fixed it! I can program for hours and always get stuck on one tiny little thing.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: