Table with Alternating BG Colored Rows

07-01-2007, 5:10 PM

Hi--

I was wondering if the there is an if statement that would check whether a
retrieved row from a mysql table was an even or odd number?

All My Best,
Jeffrey

07-01-2007, 5:10 PM

On Sat, 16 Aug 2003 16:39:47 -0700 in
<message-id:BB640ED3.56622%support@groundlevel.net>
Jeffrey Ellis <support@groundlevel.net> wrote:

> Hi--
>
> I was wondering if the there is an if statement that would check
> whether a retrieved row from a mysql table was an even or odd number?
>
> All My Best,
> Jeffrey
>
>
>

$i = 0;
while ($stuff = @mysql_fetch_assoc($result)) {
$row_class = (($i % 2) == 0) ? 'light' : 'dark';

echo "<td class=\"$row_class\">$stuff['foo']</td>";

$i++;
}

Assuming you have a 'light' and 'dark' class. The % (modulo) checks to
see if $i is an odd or even number, and will return the colour
accordingly =)

HTH.

Regards,

Ian

--
Ian.H [Design & Development]
digiServ Network - Web solutions
www.digiserv.net | irc.digiserv.net | forum.digiserv.net
Programming, Web design, development & hosting.

07-01-2007, 5:11 PM

in article 20030817004836.59d01eef.ian@WINDOZEdigiserv.net, Ian.H [dS] at
ian@WINDOZEdigiserv.net wrote on 8/16/03 4:48 PM:

> On Sat, 16 Aug 2003 16:39:47 -0700 in
> <message-id:BB640ED3.56622%support@groundlevel.net>
> Jeffrey Ellis <support@groundlevel.net> wrote:
>
>> Hi--
>>
>> I was wondering if the there is an if statement that would check
>> whether a retrieved row from a mysql table was an even or odd number?
>>
>> All My Best,
>> Jeffrey
>>
>>
>>
>
> $i = 0;
> while ($stuff = @mysql_fetch_assoc($result)) {
> $row_class = (($i % 2) == 0) ? 'light' : 'dark';
>
> echo "<td class=\"$row_class\">$stuff['foo']</td>";
>
> $i++;
> }
>
>
> Assuming you have a 'light' and 'dark' class. The % (modulo) checks to
> see if $i is an odd or even number, and will return the colour
> accordingly =)

Hi, Ian--

Thank you...this looks great!

Please excuse my ignorance (again <G>), but...a class? Can you tell me how
to define that?

All My Best,
Jeffrey

07-01-2007, 5:11 PM

in article 20030817021632.3cc0f3b5.ian@WINDOZEdigiserv.net, Ian.H [dS] at
ian@WINDOZEdigiserv.net wrote on 8/16/03 6:16 PM:

> On Sat, 16 Aug 2003 18:06:02 -0700 in
> <message-id:BB64230A.5662D%support@groundlevel.net>
> Jeffrey Ellis <support@groundlevel.net> wrote:
>
>> Hi, Ian--
>>
>> Thank you...this looks great!
>
>
> No probs =)
>
>
>>
>> Please excuse my ignorance (again <G>), but...a class? Can you tell
>> me how to define that?
>
>
> The class will be defined in your CSS (Cascading Style Sheets). This
> part actually has nothing to do with PHP, but the HTML side of things.
>
> Forgive me if I over-simplify this next part, as I don't know what
> you've used in your files, or how much you've covered CSS etc...
>
> In you HTML <head></head> section, you can use a line such as:
>
>
> <link rel="stylesheet" href="/path/to/default.css" type="text/css" />
> ('default.css' can be anything you like)
>
>
> This would then load your CSS file from that location. 'default.css'
> would contain code for your alt. colours such as:
>
>
> .light {
> color:#000;
> background-color:#eee;
> }
>
> .dark {
> color:#000;
> background-color:#aaa;
> }
>
>
> The '.' defines these as a 'class'.. much like structs in C etc.
>
> Just to complete the explanation, sometimes, you'll find things like:
>
>
> <td id="light">
>
>
> etc.. an 'id' can only be used once on a page (possibly for a logo
> definition or the likes), whereas a class can be used repeatedly (like
> you'd require for your alt. rows).
>
> An 'id' defined in CSS will look like:
>
>
> #light {
> ...
> }
>
>
> The '#' defining an 'id'.
>
> The beauty of this, is if you include the <link ....> line on all of
> your pages, and you say, wanted to change the light colour from the grey
> defined in my example to yellow, you only have to change the value in
> the CSS file for it to affect the entire site, whereas the "old" style
> of using 'bgcolor="#eeeeee"; etc, means that you could have a _lot_ of
> modifications to make to perform the same change.
>
> Sites like:
>
>
> <URL:http://www.webmonkey.com/>
>
>
> have some more info on CSS if necessary, and obviously google.. but if
> you're not using it as yet, it'd go highly recommended for easy
> maintenance, and less code during development =)
>
>
>>
>> All My Best,
>> Jeffrey
>
>
> HTH / clarifies further.

Hi, Ian--

Yes...I think I have it now...I'll give it a go!

Thank you!

All My Best,
Jeffrey

07-01-2007, 5:11 PM

in article 20030817021632.3cc0f3b5.ian@WINDOZEdigiserv.net, Ian.H [dS] at
ian@WINDOZEdigiserv.net wrote on 8/16/03 6:16 PM:

> On Sat, 16 Aug 2003 18:06:02 -0700 in
> <message-id:BB64230A.5662D%support@groundlevel.net>
> Jeffrey Ellis <support@groundlevel.net> wrote:
>
>> Hi, Ian--
>>
>> Thank you...this looks great!
>
>
> No probs =)
>
>
>>
>> Please excuse my ignorance (again <G>), but...a class? Can you tell
>> me how to define that?
>
>
> The class will be defined in your CSS (Cascading Style Sheets). This
> part actually has nothing to do with PHP, but the HTML side of things.
>
> Forgive me if I over-simplify this next part, as I don't know what
> you've used in your files, or how much you've covered CSS etc...
>
> In you HTML <head></head> section, you can use a line such as:
>
>
> <link rel="stylesheet" href="/path/to/default.css" type="text/css" />
> ('default.css' can be anything you like)
>
>
> This would then load your CSS file from that location. 'default.css'
> would contain code for your alt. colours such as:
>
>
> .light {
> color:#000;
> background-color:#eee;
> }
>
> .dark {
> color:#000;
> background-color:#aaa;
> }
>
>
> The '.' defines these as a 'class'.. much like structs in C etc.
>
> Just to complete the explanation, sometimes, you'll find things like:
>
>
> <td id="light">
>
>
> etc.. an 'id' can only be used once on a page (possibly for a logo
> definition or the likes), whereas a class can be used repeatedly (like
> you'd require for your alt. rows).
>
> An 'id' defined in CSS will look like:
>
>
> #light {
> ...
> }
>
>
> The '#' defining an 'id'.
>
> The beauty of this, is if you include the <link ....> line on all of
> your pages, and you say, wanted to change the light colour from the grey
> defined in my example to yellow, you only have to change the value in
> the CSS file for it to affect the entire site, whereas the "old" style
> of using 'bgcolor="#eeeeee"; etc, means that you could have a _lot_ of
> modifications to make to perform the same change.
>
> Sites like:
>
>
> <URL:http://www.webmonkey.com/>
>
>
> have some more info on CSS if necessary, and obviously google.. but if
> you're not using it as yet, it'd go highly recommended for easy
> maintenance, and less code during development =)
>
>
>>
>> All My Best,
>> Jeffrey
>
>
> HTH / clarifies further.

Hi, Ian--

It works great! Thank you!

All My Best,
Jeffrey

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic Creation of Rows	Mr. Clean	PHP	4	07-01-2007 3:18 PM
Delete from a table using entries in temp table	n00bie	Database	2	06-10-2007 12:25 AM
table in a table	Piotr	Database	4	06-10-2007 12:23 AM
creating unique rows	VB.NET	Database	1	06-10-2007 12:20 AM
Calculated rows	neeper	Database	0	05-31-2007 8:42 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)