MySQL table display with PHP/HTML

[cerpher]

I all, newbie 7 weeks.
using PHP 5.0, Apache 2.0, and MySQL 5.0

have a table I want to show with section in different color to seperate data.

This works fine and the data show up from MySQL.

Here is my code below...................

<?php

mysql_connect("localhost","user","pswd");
@mysql_select_db("mydb");
$query="SELECT * FROM table";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

?>

<?
$i=0;
while ($i < $num) {
$title=mysql_result($result,$i,"title");
$address=mysql_result($result,$i,"address");
$city=mysql_result($result,$i,"city");
$zip=mysql_result($result,$i,"zip");
$county=mysql_result($result,$i,"county");

?>

<table border="0" cellspacing="1" cellpadding="1">

<TR>

<TD><IMG SRC="images/washout.jpg" WIDTH="50" HIEGHT="50"></TD>
<TD WIDTH="200"><? echo "$title"; ?></TD>
<TD WIDTH="200"><? echo "$zip"; ?></TD>

</TR><TR>

<TD WIDTH="100">&nbsp</TD>
<TD WIDTH="100"><? echo "$address"; ?></TD>
<TD WIDTH="100"><? echo "$county"; ?></TD>

</TR><TR>

<TD WIDTH="50"></TD>
<TD WIDTH="200"><? echo "$city"; ?></TD>
<TD WIDTH="50"><? echo "$telephone"; ?></TD>

</TR>

<?
++$i;
}
echo "</table>";

Thanks
JC

[Matt_Kindig]

How would you like to separate the data by color, i.e. a different color for each section, a different color for each line, or what...? Can you give us more information about what you are trying to do?

[cerpher]

Matt Kindig wrote:

How would you like to separate the data by color, i.e. a different color for each section, a different color for each line, or what...? Can you give us more information about what you are trying to do?

Yes that would be nice or just 2 color i.e. white and gray for each section.
I figured the html tag or php code would be the same no matter which way it was.

[cerpher]

Post this after your table insert.

<hr width='100%' style="height:2">

but still do not know how to do color for each section

I know the tag for color for a single table
<table bgcolor="red">

[maxpup979]

<?php

mysql_connect("localhost","user","pswd");
@mysql_select_db("mydb");
$query="SELECT * FROM table";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

?>

<?
$i=0;
while ($i < $num) {
$title=mysql_result($result,$i,"title");
$address=mysql_result($result,$i,"address");
$city=mysql_result($result,$i,"city");
$zip=mysql_result($result,$i,"zip");
$county=mysql_result($result,$i,"county");
########################maxpup added this line#########
if($i%2==0){$bgcolor="white";}else{$bgcolor="grey";}
################################################
#Maxpup also changed the table decl. by adding a bgcolor attrib
?>

<table border="0" cellspacing="1" cellpadding="1" bgcolor="<?php echo $bgcolor;?>">

<TR>

<TD><IMG SRC="images/washout.jpg" WIDTH="50" HIEGHT="50"></TD>
<TD WIDTH="200"><? echo "$title"; ?></TD>
<TD WIDTH="200"><? echo "$zip"; ?></TD>

</TR><TR>

<TD WIDTH="100">&nbsp</TD>
<TD WIDTH="100"><? echo "$address"; ?></TD>
<TD WIDTH="100"><? echo "$county"; ?></TD>

</TR><TR>

<TD WIDTH="50"></TD>
<TD WIDTH="200"><? echo "$city"; ?></TD>
<TD WIDTH="50"><? echo "$telephone"; ?></TD>

</TR>


<?
++$i;
}
echo "</table>";

[cerpher]

maxpup979 wrote:

########################maxpup added this line#########
if($i%2==0){$bgcolor="white";}else{$bgcolor="grey";}
################################################
#Maxpup also changed the table decl. by adding a bgcolor attrib
?>

THX Maxpup979

wow one line of code can make color
Now I have White and Green (suppose to be grey)

Thanks again MaxPuP979 for making my world from B&W to Color

JC