Alternating row colours

asgsoft · 04-08-2006, 02:32 AM

Have you ever wanted to make a table with alternating row colours?

Well I did it for a site and thought it would be great to share it. Here

PHP Code:

  <?php

//connect to db and select table

$db1 = mysql_connect("host", "user", "pass");

mysql_select_db("$db",$db1);

$table = "tablename"; //table name

 
 
$list = mysql_query("SELECT * FROM `$table` ORDER BY `coulmn_name` ASC "); // the SQL of the table you will show

echo"<h3><p align=center> $table <p></h3>"; //title for the page

echo('<table width="500px" height="110px" style="font-family: Verdana; border: 1px solid black;" align="center" cellpadding="2" cellspacing="1" border="0">'); //add the table

echo('<tr align="center"><td><b><u>Date</u></b></td><td><b><u>description</u></b></td></tr>'); // top row with the titles

while($get=mysql_fetch_array($list))

{

//chooses colous

if ($color == "CCFFCC")

{

$color = "FFFFFF";//change the code

}

else

{

$color = "CCFFCC"; //change the code

}

 
echo('<tr bgcolor=#'.$color.' align="center">  <td>'. $get['Date'] .'</td><td>'. $get['description'] .'</td></tr>');  //add the contents

}

echo("</table>"); //finish the table

 
?>

See it on action at: http://www.asgsoft.net/mosque/view%2...0a%20month.php

Epic · 04-09-2006, 05:09 PM

Thank you!!!! This is exactly what I've been looking for lately...I'll try this out as soon as I can get my monitor working

But thank you so much!

wackyjoe · 04-09-2006, 10:07 PM

Nice Tutorial ... another way would be:

PHP Code:

  echo "<table>";

$color1 = "#EEEEEE"; 

$color2 = "#FFFFFF"; 

$rowc = 0; 

 
$sql = mysql_query("SELECT * FROM places ORDER BY id LIMIT 5");

 
while ($row = mysql_fetch_array($sql) { 

 
$row_color = ($rowc % 2) ? $color1 : $color2;  //basicly like a if()

 
echo "

   <tr>

    <td width="110" bgcolor="$row_color" nowrap>

????: NamePros.com http://www.namepros.com/webmaster-tutorials/185019-alternating-row-colours.html
    $article_date</td>

    <td bgcolor="$row_color">

    <a href="whteva.php?cmd=full_article&article_id=$article_id">$article_title</a></td>

????: NamePros.com http://www.namepros.com/showthread.php?t=185019
    </tr>";

   

   

 
    $rowc++; //increment by 1

} 

echo"</table>";

apexad · 06-13-2006, 07:53 AM

I used something similar to this on my site (in my signature) it works really well. Tables can be hard to read, but alternating colors adds just enough of a difference that you can navigate through them.

rep points added to you guys!

psalzmann · 06-14-2006, 12:38 AM

Originally Posted by wackyjoe

Nice Tutorial ... another way would be:

PHP Code:

  echo "<table>";

$color1 = "#EEEEEE"; 

$color2 = "#FFFFFF"; 

$rowc = 0; 

 
$sql = mysql_query("SELECT * FROM places ORDER BY id LIMIT 5");

 
while ($row = mysql_fetch_array($sql) { 

 
$row_color = ($rowc % 2) ? $color1 : $color2;  //basicly like a if()

????: NamePros.com http://www.namepros.com/showthread.php?t=185019
 
echo "

   <tr>

????: NamePros.com http://www.namepros.com/showthread.php?t=185019
    <td width="110" bgcolor="$row_color" nowrap>

    $article_date</td>

    <td bgcolor="$row_color">

    <a href="whteva.php?cmd=full_article&article_id=$article_id">$article_title</a></td>

    </tr>";

   

   

 
    $rowc++; //increment by 1

} 

echo"</table>";

Yes, this is the best way I found. I've been using this way ever since

rmal · 06-14-2006, 09:33 AM

The second way is usually the method that I use, just much simpler putting the if on one line.

04-08-2006, 02:32 AM	THREAD STARTER #1 (permalink)
asgsoft NamePros Regular Join Date: Sep 2005 Location: At Home Posts: 881	Alternating row colours Have you ever wanted to make a table with alternating row colours? Well I did it for a site and thought it would be great to share it. Here PHP Code: <?php //connect to db and select table $db1 = mysql_connect("host", "user", "pass"); mysql_select_db("$db",$db1); $table = "tablename"; //table name $list = mysql_query("SELECT * FROM `$table` ORDER BY `coulmn_name` ASC "); // the SQL of the table you will show echo"<h3><p align=center> $table <p></h3>"; //title for the page echo('<table width="500px" height="110px" style="font-family: Verdana; border: 1px solid black;" align="center" cellpadding="2" cellspacing="1" border="0">'); //add the table echo('<tr align="center"><td><b><u>Date</u></b></td><td><b><u>description</u></b></td></tr>'); // top row with the titles while($get=mysql_fetch_array($list)) { //chooses colous if ($color == "CCFFCC") { $color = "FFFFFF";//change the code } else { $color = "CCFFCC"; //change the code } echo('<tr bgcolor=#'.$color.' align="center"> <td>'. $get['Date'] .'</td><td>'. $get['description'] .'</td></tr>'); //add the contents } echo("</table>"); //finish the table ?> See it on action at: http://www.asgsoft.net/mosque/view%2...0a%20month.php __________________ Free SEO and Domain tools \|HTML ENT\| Your Source to expired domains with PageRank & tips

04-09-2006, 05:09 PM	#2 (permalink)
Epic Senior Member Join Date: Sep 2005 Posts: 3,767	Thank you!!!! This is exactly what I've been looking for lately...I'll try this out as soon as I can get my monitor working But thank you so much! __________________ Attractive, Compelling, Efficient Web Design & Development

06-13-2006, 07:53 AM	#4 (permalink)
apexad NamePros Regular Join Date: Jul 2005 Location: www.restaurantselector.com Posts: 738	I used something similar to this on my site (in my signature) it works really well. Tables can be hard to read, but alternating colors adds just enough of a difference that you can navigate through them. rep points added to you guys! __________________ keira knightley

06-14-2006, 09:33 AM	#6 (permalink)
rmal New Member Join Date: Jun 2006 Location: whitewater, wi Posts: 16	The second way is usually the method that I use, just much simpler putting the if on one line. __________________ ~Ryan Ryan's Life my personal blog, it's not about anything

04-09-2006, 10:07 PM	#3 (permalink)
wackyjoe NamePros Regular Join Date: Dec 2005 Posts: 210	Nice Tutorial ... another way would be: PHP Code: echo "<table>"; $color1 = "#EEEEEE"; $color2 = "#FFFFFF"; $rowc = 0; $sql = mysql_query("SELECT * FROM places ORDER BY id LIMIT 5"); while ($row = mysql_fetch_array($sql) { $row_color = ($rowc % 2) ? $color1 : $color2; //basicly like a if() echo " <tr> <td width="110" bgcolor="$row_color" nowrap> ????: NamePros.com http://www.namepros.com/webmaster-tutorials/185019-alternating-row-colours.html $article_date</td> <td bgcolor="$row_color"> <a href="whteva.php?cmd=full_article&article_id=$article_id">$article_title</a></td> ????: NamePros.com http://www.namepros.com/showthread.php?t=185019 </tr>"; $rowc++; //increment by 1 } echo"</table>";

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