[RESOLVED] Row color NOT alternate but...

BlueDutch

I am begining to think it isn´t possible with php but perhaps with java. I want to colour the top 3 rows of result output table green, the next 4 blue and the last two red with everything else inbetween default. I have searched high and low for a solution but I am stuck. Can anyone please help me in the right direction?😕

djjjozsi

when you print out the <tr><td></td><td></td> </tr> tags in your while cycle,
check the row's number.

<?php
if($rownumber<=9)
$rowbg="#CCCCCC";

if($rownumber<=6)
$rowbg="#66CCFF";

if($rownumber<=2)
$rowbg="#99FFCC";
?>

after you have the background, print out the rows with the selected background.

<?php
while($row=mysql_fetch_assoc($results))
{
// here comes the $rownumber check

?>
  <tr>
    <td bgcolor="<?php echo $rowbg ?>">&nbsp;</td>
    <td bgcolor="<?php echo $rowbg ?>">&nbsp;</td>
  </tr>
<?php
$rownumber++;
}

?>

i know this can make with CSS, i suggest make it with stylesheets.

laserlight

BlueDutch wrote:
I am begining to think it isn´t possible with php but perhaps with java. I want to colour the top 3 rows of result output table green, the next 4 blue and the last two red with everything else inbetween default. I have searched high and low for a solution but I am stuck. Can anyone please help me in the right direction?

The right direction with respect to PHP is to get your PHP script to add say, class attributes to the relevant HTML elements, then use CSS to style. The right direction with respect to Java depends on what you are doing with Java, but my guess is that you are thinking of Javascript, not Java, in which case Javascript can also be used in conjunction with CSS.

BlueDutch

djjjozsi;10918521 wrote:
when you print out the <tr><td></td><td></td> </tr> tags in your while cycle,
check the row's number.
<?php
if($rownumber<=9)
$rowbg="#CCCCCC";

if($rownumber<=6)
$rowbg="#66CCFF";

if($rownumber<=2)
$rowbg="#99FFCC";
?>
after you have the background, print out the rows with the selected background.
<?php
while($row=mysql_fetch_assoc($results))
{
// here comes the $rownumber check

?>
  <tr>
    <td bgcolor="<?php echo $rowbg ?>">&nbsp;</td>
    <td bgcolor="<?php echo $rowbg ?>">&nbsp;</td>
  </tr>
<?php
$rownumber++;
}

?>
i know this can make with CSS, i suggest make it with stylesheets.

Thank you very much for this. I will attempt to put it into practice later. I had tried something similar a while back but it wouldn´t work in the same context as atlternate row colour, so I decided I would have to ditch the alternate row colour in order to get the top and bottom row colours how I wanted them. Thanks again.

BlueDutch

laserlight;10918522 wrote:
The right direction with respect to PHP is to get your PHP script to add say, class attributes to the relevant HTML elements, then use CSS to style. The right direction with respect to Java depends on what you are doing with Java, but my guess is that you are thinking of Javascript, not Java, in which case Javascript can also be used in conjunction with CSS.

Yes I did mean a javascript as opposed to java, sorry my bad. Thank you for your help. 🙂

BlueDutch

djjjozsi;10918521 wrote:
when you print out the <tr><td></td><td></td> </tr> tags in your while cycle,
check the row's number.
<?php
if($rownumber<=9)
$rowbg="#CCCCCC";

if($rownumber<=6)
$rowbg="#66CCFF";

if($rownumber<=2)
$rowbg="#99FFCC";
?>
after you have the background, print out the rows with the selected background.
<?php
while($row=mysql_fetch_assoc($results))
{
// here comes the $rownumber check

?>
  <tr>
    <td bgcolor="<?php echo $rowbg ?>">&nbsp;</td>
    <td bgcolor="<?php echo $rowbg ?>">&nbsp;</td>
  </tr>
<?php
$rownumber++;
}

?>
i know this can make with CSS, i suggest make it with stylesheets.

Ok I got this working but still one problem. The colors don´t show up as they should. No matter which colors I use they stay within the range of greens and blues, so I cannot get the correct colors to display in the correct areas. I have removed the coding completely for alternate coloring and I am using just the code you suggested. Even if I choose white for all three sets of rows the colors come back turquoise. Any ideas pleeease?

djjjozsi

    while ( $row = mysql_fetch_assoc( $result ) ) {
$rowbg="";

so you need to add a default value to the $rowbg variable.

You can add a background to a <tr> (whole row).

print "<tr$rowbg>";

try to solve it with CSS.

BlueDutch

djjjozsi;10918647 wrote:
    while ( $row = mysql_fetch_assoc( $result ) ) {
$rowbg="";
so you need to add a default value to the $rowbg variable.

You can add a background to a <tr> (whole row).
print "<tr$rowbg>";
try to solve it with CSS.

I have rewritten my CSS and it doesn´t change anything. Does it make a difference quoting the hex value or the colour code? I have tried both and nothing doing.:queasy:

djjjozsi

show us the relevant codes, please.
i've tested with these colors.

<style type="text/css">
<!--
.green {
	background-color: #CCFFCC;
}
.blue {
	background-color: #87D9FC;
}
.lightgray {
	background-color: #F4F4F4;
}
-->
</style>

<tr class="green">
</tr>

BlueDutch

echo "<table align=center bgcolor='#ffffff' border='0' width=50%>
<tr class='green'>
<th></th>
</tr>";
$count = 1 + $s ;
while ($row= mysql_fetch_array($result)) {
$rowbg='white';
if($rownumber<=21)
$rowbg='#F4F4F4';
if($rownumber<=6)
$rowbg='#87D9FC';
if($rownumber<=2)
$rowbg='#CCFFCC';
$title = $row["1st_field"];
echo "<tr>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='right'><font color='green'>" . $count;$row["$title"] . "</font></td>";
echo "<td width='150' bgcolor='<?php echo $rowbg ?>' nowrap align='left'><font color='#00089c'>" . $row["tname"] ."</font></td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["P"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["W"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["D"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["L"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["F"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["A"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["W"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["D"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["L"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["F"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["A"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'><font color='red'>" . $row["PTS"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["GD"] . "</td>";
$count++ ;
$rownumber++;
}
echo "</tr>";
echo "</table>";

This with just your code in the style sheet and absolutely nothing else except for font face verdana.

djjjozsi

this is one row only:

echo "<td width='20' bgcolor='$rowbg' nowrap align='center'>" . $row["P"] . "</td>";

Could you re-edit your previous post with the php bb tags please?

BlueDutch

Yes I know it is only one row, that is because it is reading 24 rows from a database as a league table. Unless I have to read the first three, give them a bgcolor, then the next 4 and do the same et al looping back to the begining each time. In that case it wouldnt work as the same results would be read over and over unless each script was changed slightly to avoid repetition. This would require far more work than it is worth I think. Or perhaps I am wrong because I am only a beginnner in php and mysql, so I will bow to your greater knowledge 🙂

BlueDutch

djjjozsi;10918657 wrote:
this is one row only:
echo "<td width='20' bgcolor='$rowbg' nowrap align='center'>" . $row["P"] . "</td>";
Could you re-edit your previous post with the php bb tags please?

echo "<table align=center bgcolor='#ffffff' border='0' width=50%>
<tr class='green'>
<td></td>
</tr>";
$count = 1 + $s ;
while ($row= mysql_fetch_array($result)) {
$rowbg='white';
if($rownumber<=21)
$rowbg='#F4F4F4';
if($rownumber<=6)
$rowbg='#87D9FC';
if($rownumber<=2)
$rowbg='#CCFFCC';
$title = $row["1st_field"];
echo "<tr>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='right'><font color='green'>" . $count;$row["$title"] . "</font></td>";
echo "<td width='150' bgcolor='<?php echo $rowbg ?>' nowrap align='left'><font color='#00089c'>" . $row["tname"] ."</font></td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["P"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["W"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["D"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["L"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["F"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["A"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["W"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["D"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["L"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["F"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["A"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'><font color='red'>" . $row["PTS"] . "</td>";
echo "<td width='20' bgcolor='<?php echo $rowbg ?>' nowrap align='center'>" . $row["GD"] . "</td>";
$count++ ;
$rownumber++;
$rowcount++;
}
echo "</tr>";
echo "</table>";

This is with your CSS in place. I will leave the page as it appears for now, you can find it at http://www.upthedale.com/2009tab.php

djjjozsi

see the difference

<?php

//print the table 

?><table align=`center` bgcolor='#ffffff' border='0' width=`50%`>
<tr class='green'>
<td></td>
</tr><?php

$count = 1 + $s ;
while ($row= mysql_fetch_assoc($result)) {
$rowbg='#FFFFFF';
if($rownumber<=21)
$rowbg='#F4F4F4';
if($rownumber<=6)
$rowbg='#87D9FC';
if($rownumber<=2)
$rowbg='#CCFFCC';
$title = $row["1st_field"];
echo "<tr bgcolor='$rowbg'>";
echo "<td width='20 nowrap align='right'><font color='green'>" . $count.$row["$title"] . "</font></td>";
echo "<td width='150 nowrap align='left'><font color='#00089c'>" . $row["tname"] ."</font></td>";
echo "<td width='20' nowrap align='center'>" . $row["P"] . "</td>";
echo "<td width='20' nowrap align='center'>" . $row["W"] . "</td>";
echo "<td width='20' nowrap align='center'>" . $row["D"] . "</td>";
echo "<td width='20' nowrap align='center'>" . $row["L"] . "</td>";
echo "<td width='20' nowrap align='center'>" . $row["F"] . "</td>";
echo "<td width='20' nowrap align='center'>" . $row["A"] . "</td>";
echo "<td width='20' nowrap align='center'>" . $row["W"] . "</td>";
echo "<td width='20' nowrap align='center'>" . $row["D"] . "</td>";
echo "<td width='20' nowrap align='center'>" . $row["L"] . "</td>";
echo "<td width='20' nowrap align='center'>" . $row["F"] . "</td>";
echo "<td width='20' nowrap align='center'>" . $row["A"] . "</td>";
echo "<td width='20' nowrap align='center'><font color='red'>" . $row["PTS"] . "</font></td>";
echo "<td width='20 nowrap align='center'>" . $row["GD"] . "</td>";
$count++ ;
$rownumber++;
$rowcount++;
echo "</tr>"; //this was outside in your version
}

echo "</table>";
?>

BlueDutch

That´s great I can´t thank you enough, I would never have spotted it as I had looked at it for too long. Sorry for the late reply as it had sent me to sleep all the frustration.

djjjozsi

All right 🙂 Your welcome.

don't forget to set this thread as resolved if you think this question has replied.

jjozsi.