[RESOLVED] php or html?

[roscor]

Hi

I have a table which draws data from my database. I display the information in a table. When there is multiple records I wish for every altenative displayed row to be diplayed in its own color to easily distiguish between before and after rows. I have done it with a boarded table but it does not look good.

My question is this a pure a HTML issue or is it done with php. here is some code that i am using at the moment.

<table cellSpacing="0" cellPadding="1" border="0" id="RecentFeedback" class="itemTable" width="800" >
<tr height="45" bgcolor="#D6DEFF">
<td  align="center"><font face="Veranda" size="2" color="#000000">County&nbsp;</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Left</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Rent </td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Looked</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Damaged</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Complaints</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Difficulties</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Evicted</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Rent</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Date Record Submitted</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">ID</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Overall Percentage %</td>
<?
$i=0;
while ($i < $num) {

$county=mysql_result($result,$i,"county");
$left=mysql_result($result,$i,"left");       

$rent=mysql_result($result,$i,"rent");
$look=mysql_result($result,$i,"look");
$dam=mysql_result($result,$i,"dam");
$comp=mysql_result($result,$i,"comp");
$diff=mysql_result($result,$i,"diff");
$evic=mysql_result($result,$i,"evic");
$would=mysql_result($result,$i,"would");
$date=mysql_result($result,$i,"date");
$id=mysql_result($result,$i,"id");
?>

<tr>
<form action="result.php" method="get">
<th><input type="hidden" size="20%" value="<? echo $county; ?>" name="county">&nbsp;<? echo $county; ?>&nbsp;</th>
<th><input type="hidden" size="25%" value="<? echo $left; ?>" name="left"><? echo $left; ?><?
    if ($left == "Yes"){

       echo "<font color = #00FF00 >$pos1</font>";
       $pos1 = '12.5';
 } 
      else {                         

           echo "<font color = #FF0000>$neg1</font>";
           $pos1 = '0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $rent; ?>" name="rent"><? echo $rent; ?><?
    if($rent == "No"){

        echo "<font color = #00FF00 >$pos2</font>";
        $pos2 = '12.5';
 } 
      else {
            echo "<font color = #FF0000>$neg2</font>";
            $pos2 = '0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $look; ?>" name="looked"><? echo $look; ?><?
    if ($look == "Yes"){

       echo "<font color = #00FF00 >$pos3</font>";
       $pos3 = '12.5';
 } 
      else {                         

           echo "<font color = #FF0000>$neg3</font>";
           $pos3 = '0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $dam; ?>" name="dam"><? echo $dam; ?><?
    if($dam == "No"){
           echo "<font color = #00FF00 >$pos4</font>";
           $pos4 ='12.5';
 } 
      else {              

           echo "<font color = #FF0000>$neg4</font>";
           $pos4 = '0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $comp; ?>" name="comp"><? echo $comp; ?><?
    if($comp == "No"){
            echo "<font color = #00FF00 >$pos5</font>";
            $pos5 = '12.5';
 } 
      else {              

            echo "<font color = #FF0000>$neg5</font>";
            $pos5 = '0';
       }


?>   </th>
<th><input type="hidden" size="25%" value="<? echo $diff; ?>" name="diff"><? echo $diff; ?><?
    if($diff == "No"){
            echo "<font color = #00FF00 >$pos6</font>";
            $pos6 = '12.5';
 } 
      else {              

             echo "<font color = #FF0000>$neg6</font>";
             $pos6 ='0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $evic; ?>" name="evic"><? echo $evic; ?><?
    if($evic == "No"){
           echo "<font color = #00FF00 >$pos7</font>";
           $pos7 = '12.5';
 } 
      else {              

            echo "<font color = #FF0000>$neg7</font>";
            $pos7 = '0';
       }



?>   </th>
<th><input type="hidden" size="25%" value="<? echo $would; ?>" name="would"><? echo $would; ?><?
    if($would == "Yes"){

        echo "<font color = #00FF00 >$pos8</font>";
        $pos8 = '12.5';
 } 
      else {   

        echo "<font color = #FF0000>$neg8</font>";
        $pos8 = '0';
   }




 if ($total !=1) {

     $percentage =$pos8+$pos7+$pos6+$pos5+$pos4+$pos3+$pos2+$pos1; 
}
    else {






   }

$pos1 ="+";
$neg1 ="-";
$pos2 ="+";
$neg2 ="-";
$pos3 ="+";
$neg3 ="-";
$pos4 ="+";
$neg4 ="-";
$pos5 ="+";
$neg5 ="-";
$pos6 ="+";
$neg6 ="-";
$pos7 ="+";
$neg7 ="-";
$pos8 ="+";
$neg8 ="-";


?>
</th>
<th><input type="hidden" size="20%" value="<? echo $date; ?>" name="datesubmitted"><? echo $date; ?></th>
<th><input type="hidden" size="20%" value="<? echo $landlordloid; ?>" name="id"><? echo $id; ?></th>
<th><input type="hidden" size="20%" value="<? echo $percentage; ?>" name="percentage">&nbsp;<?
if ($percentage >= 87.5) {
    $color = '#00FF00';
} elseif ($percentage >= 37.5) {
    $color = '#ff9900';
} else {
    $color = 'red';
}
echo '<b style="color:' . $color . '">' . $percentage . '</b>';
  ?>&nbsp;</th>
</form>


</tr>

<?
$i++;
}


echo "</table>";

?>

As you can see there is a loop and on some occasions there are many records displayed, this looks awfull in a large table with the data difficult to read and seperate by the eye.

Any advice is much appreciated.

[roscor]

Appologies, still very much a newbie.

Just trawling through threads and FAQ for the answer. I have tried many of the variations of code but cannot get it to work with what I have already wrote.

Any sugestions of how to incorporate onto my code will be very much appreciated.

I have been trying this etc but the whole table fills with the bgcolor

@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM ten_data WHERE ten_id='$tenant_detailsid' ORDER by date DESC";

$result=mysql_query($query);

$num=mysql_numrows($result);

//mysql_data_seek($result, 0);


echo "<b><center>Example Database Result</center></b><br>";

for($i=1 ; $i<=$nu-1 ;$i++)
{
  $color = ($i%2==0)?'ffffff':'cccccc';  

  }


if ($num==0) {


echo "No Matching Data Held against $first $last $dob";

}

$pos1 ="+";
$neg1 ="-";
$pos2 ="+";
$neg2 ="-";
$pos3 ="+";
$neg3 ="-";
$pos4 ="+";
$neg4 ="-";
$pos5 ="+";
$neg5 ="-";
$pos6 ="+";
$neg6 ="-";
$pos7 ="+";
$neg7 ="-";
$pos8 ="+";
$neg8 ="-";




mysql_close();





 ?>






<div align="left">
    <tr>

   <td width="50%" height="50" valign="top" rowspan="14" align="left">



<div align="left">

<p>          <form action="test.php" method="get" align="left">



<table border="1" cellpadding="7" cellspacing="0" bordercolor="#111111" width="778" id="AutoNumber1">


  <tr>
    <td width="14%" align="left">Tenant Details:</td>
    <td width="50%">
    <? echo $first; ?>&nbsp;&nbsp;<? echo $last; ?>&nbsp;&nbsp;<? echo $dob; ?></td> 
    </tr>
    <tr>
    <td width="14%" align="left">Tenant No:</td>
    <td width="50%">
    <? echo $id; ?></td> 
    </tr>  

  </table>


  <hr>
  <div class="scrollable" style="height:250px; width:778; overflow:auto;"> 




  <center>



  <table border="0" width="778" height="50"  bordercolor="#111111">


<tr>

  <td width="778" height="50" valign="top"   bordercolor="#111111">



</div>
<table cellSpacing="0" cellPadding="1" border="0" id="RecentFeedback" class="itemTable" width="800" >
<tr height="45" bgcolor="#D6DEFF">
<td  align="center"><font face="Veranda" size="2" color="#000000">County&nbsp;</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Left on Good Terms</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Left Property with Rent Arrears</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Looked after Property </td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Damaged Caused</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Complaints from Anyone</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Difficulties obtaining rent</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Evicted From Property</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Would rent Again</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Date Record Submitted</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Landlord ID</td>
<td  align="center"><font face="Veranda" size="2" color="#000000">Overall Percentage %</td>
<?
$i=0;
while ($i < $num) {

$county=mysql_result($result,$i,"county");
$left=mysql_result($result,$i,"leftongoodterms");       

$rent=mysql_result($result,$i,"rentarrears");
$look=mysql_result($result,$i,"lookedafterproperty");
$dam=mysql_result($result,$i,"damagecaused");
$comp=mysql_result($result,$i,"complaintneighbourpolice");
$diff=mysql_result($result,$i,"difficultyobtainingrent");
$evic=mysql_result($result,$i,"evicted");
$would=mysql_result($result,$i,"wouldrentagain");
$date=mysql_result($result,$i,"date");
$landlordloid=mysql_result($result,$i,"landlordloid");
?>

<tr bgcolor="$color">
<form action="result.php" method="get">
<th><input type="hidden" size="20%" value="<? echo $county; ?>" name="county">&nbsp;<? echo $county; ?>&nbsp;</th>
<th><input type="hidden" size="25%" value="<? echo $left; ?>" name="leftongoodterms"><? echo $left; ?><?
    if ($left == "Yes"){

       echo "<font color = #00FF00 >$pos1</font>";
       $pos1 = '12.5';
 } 
      else {                         

           echo "<font color = #FF0000>$neg1</font>";
           $pos1 = '0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $rent; ?>" name="rentarrears"><? echo $rent; ?><?
    if($rent == "No"){

        echo "<font color = #00FF00 >$pos2</font>";
        $pos2 = '12.5';
 } 
      else {
            echo "<font color = #FF0000>$neg2</font>";
            $pos2 = '0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $look; ?>" name="lookedafterproperty"><? echo $look; ?><?
    if ($look == "Yes"){

       echo "<font color = #00FF00 >$pos3</font>";
       $pos3 = '12.5';
 } 
      else {                         

           echo "<font color = #FF0000>$neg3</font>";
           $pos3 = '0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $dam; ?>" name="damagecaused"><? echo $dam; ?><?
    if($dam == "No"){
           echo "<font color = #00FF00 >$pos4</font>";
           $pos4 ='12.5';
 } 
      else {              

           echo "<font color = #FF0000>$neg4</font>";
           $pos4 = '0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $comp; ?>" name="complaintneighbourpolice"><? echo $comp; ?><?
    if($comp == "No"){
            echo "<font color = #00FF00 >$pos5</font>";
            $pos5 = '12.5';
 } 
      else {              

            echo "<font color = #FF0000>$neg5</font>";
            $pos5 = '0';
       }


?>   </th>
<th><input type="hidden" size="25%" value="<? echo $diff; ?>" name="difficultyobtainingrent"><? echo $diff; ?><?
    if($diff == "No"){
            echo "<font color = #00FF00 >$pos6</font>";
            $pos6 = '12.5';
 } 
      else {              

             echo "<font color = #FF0000>$neg6</font>";
             $pos6 ='0';
       }


?></th>
<th><input type="hidden" size="25%" value="<? echo $evic; ?>" name="evicted"><? echo $evic; ?><?
    if($evic == "No"){
           echo "<font color = #00FF00 >$pos7</font>";
           $pos7 = '12.5';
 } 
      else {              

            echo "<font color = #FF0000>$neg7</font>";
            $pos7 = '0';
       }



?>   </th>
<th><input type="hidden" size="25%" value="<? echo $would; ?>" name="wouldrentagain"><? echo $would; ?><?
    if($would == "Yes"){

        echo "<font color = #00FF00 >$pos8</font>";
        $pos8 = '12.5';
 } 
      else {   

        echo "<font color = #FF0000>$neg8</font>";
        $pos8 = '0';
   }




 if ($total !=1) {

     $percentage =$pos8+$pos7+$pos6+$pos5+$pos4+$pos3+$pos2+$pos1; 
}
    else {






   }

$pos1 ="+";
$neg1 ="-";
$pos2 ="+";
$neg2 ="-";
$pos3 ="+";
$neg3 ="-";
$pos4 ="+";
$neg4 ="-";
$pos5 ="+";
$neg5 ="-";
$pos6 ="+";
$neg6 ="-";
$pos7 ="+";
$neg7 ="-";
$pos8 ="+";
$neg8 ="-";


?>
</th>
<th><input type="hidden" size="20%" value="<? echo $date; ?>" name="datesubmitted"><? echo $date; ?></th>
<th><input type="hidden" size="20%" value="<? echo $landlordloid; ?>" name="landlordloid"><? echo $landlordloid; ?></th>
<th><input type="hidden" size="20%" value="<? echo $percentage; ?>" name="percentage">&nbsp;<?
if ($percentage >= 87.5) {
    $color = '#00FF00';
} elseif ($percentage >= 37.5) {
    $color = '#ff9900';
} else {
    $color = 'red';
}
echo '<b style="color:' . $color . '">' . $percentage . '</b>';
  ?>&nbsp;</th>
</form>


</tr>

<?
$i++;
}


echo "</table>";

?>

I think I may be putting the code in the wrong place?

[roscor]

Resolved it using

<?
$i=1;
while ($i < $num) 
{
//if ($foo % 2 )
if($i % 2)
{
$bg_color = '#EEEEEE';
}
else
{
$bg_color = '#FFFFFF';
}



$county=mysql_result($result,$i,"county");
?>






<form action="result.php" method="get">
<? echo "<td bgcolor=$bg_color>$county</td>"; ?>

For any one else make sure to echo the bgcolor into the form for this to work

all the best roscor