Displaying Page # in a Table

Dev Articles Community Forums Sponsor:

July 10th, 2003, 01:53 AM

mg03

Junior Member

Join Date: Jul 2003

Posts: 7

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

Displaying Page # in a Table

Hi. I have created a script that echo's database content in to a table. Now, what I want to do is have it display an increasing page # for each 5 rows. Ex:

P# | ID#
1 | 1
1 | 2
1 | 3
1 | 4
1 | 5
------
2 | 6
2 | 7
2 | 8
2 | 9
2 |10
------
3 |11
3 |12
3 |14
etc..

I hope you get the idea. If this is easy to do im gonna be mad

. I've been messing around all day trying to figure this out and have finally done what I hate doing, get help.

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) ? '#0056E4' : '#1F73FF';

    $txclass = (++$j & 1) ? 'style4'  : '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>

<?

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

  echo '<tr><td colspan="7"><HR COLOR="#1F73FF" SIZE="1"></td></tr>';

}



}

// end loop

Last edited by mg03 : July 10th, 2003 at 02:05 AM.

July 10th, 2003, 02:10 AM

avit

Not Yet Perfect

Join Date: Nov 2002

Location: Squamish, BC

Posts: 111

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

Hey hey,

Is this related to the other "group by 5" problem that I solved?

Yes, it should be simple enough to do. Put this in the beginning of your loop, before outputting the row.

PHP Code:


		
			
 $pagenumber = floor(($rowcount+5) / 5);

July 10th, 2003, 02:15 AM

mg03

Junior Member

Join Date: Jul 2003

Posts: 7

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

Thanks again. Works. I need to read up on the rounding functions.

Just when I thought I was getting good at PHP.

July 10th, 2003, 04:07 AM

digitallysmooth

you know how we do

Join Date: Jun 2002

Posts: 788

Time spent in forums: 2 h 34 m 21 sec
Reputation Power: 7

Quote:

Originally posted by mg03
Thanks again. Works. I need to read up on the rounding functions. Just when I thought I was getting good at PHP.

Actually, it would serve you well as a programmer to understand some of the basic Math related functions that are common in pretty much all programming languages. Rounding is pretty standard, so you should get familiar with these functions now and you will find you will be quick to solve other related problems much quicker.

Quote:

I've been messing around all day trying to figure this out and have finally done what I hate doing, get help.

You should never hate to get help. Getting help is a good thing.

__________________
__________________________________________________ _
Wil Moore III, MCP | Integrations Specialist | Senior Consultant
Are You Listed...? | DigitallySmooth Inc.

July 10th, 2003, 04:10 AM

mg03

Junior Member

Join Date: Jul 2003

Posts: 7

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

Maybe so, but I have a hard time understanding how the code operates when someone just gives it to me. Its hard for me to figure out how it does what it does.

July 10th, 2003, 04:39 AM

digitallysmooth

you know how we do

Join Date: Jun 2002

Posts: 788

Time spent in forums: 2 h 34 m 21 sec
Reputation Power: 7

PHP has many formats of it's manual available for download.
HTML, PDF, PalmPilot, and HTML Help file.

You can get them from here: http://www.php.net/download-docs.php

This should help you out if you need to quickly reference the manual to find out if a particular function is available.

Most of the time, if you can figure out a way to solve a problem, there is a function available that can help you solve it.

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: