Hi,
I'm having the following problem. I want to change the row color depending on the value of a record.
i made three different td class in the style.
Then i check the value of the record "TOEGEZEGD" and connect this to $NewClass,
The i try to change the color of the background.
$NewClass takes the value i want (check by display echo $NewClass)
But the background of the row doesn't change, i tried different methodes:
<td class = "$NewClass">'.$row['TOEGEZEGD'].'</td> <td class = \"$New$Class\">'.$row['VORM'].'</td> <td><DIV CLASS="$NewClass">'.$row['PAKKET'].'</DIV></td>
But non of them work
please help, it's driving my crazy
<?php
// checking for started session
function is_session_started()
{
if ( php_sapi_name() !== 'cli' ) {
if ( version_compare(phpversion(), '5.4.0', '>=') ) {
return session_status() === PHP_SESSION_ACTIVE ? TRUE : FALSE;
} else {
return session_id() === '' ? FALSE : TRUE;
}
}
return FALSE;
}
if ( is_session_started() === FALSE ) session_start();
if(isset($_SESSION ['ingelogd']) AND $_SESSION['ingelogd'] == 1)
{}
else
{
header("location:index.php");
exit;
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>**********</title>
<meta name="" content="">
</head>
<body>
<style>
textarea, input, button,
a, td, span{
font-family: "Trebuchet MS", Helvetica, sans-serif;
}
td{
color: blue;
width: 100px;
background-color: #ceffce;
height: 50px;
text-align: center;
}
td.JA{
color: red;
width: 100px;
background-color: #00ee00;
height: 50px;
text-align: left;
}
.JA{
color: red;
width: 100px;
background-color: #00ee00;
height: 50px;
text-align: left;
}
td.NEE{
color: green;
width: 100px;
background-color: #ff0000;
height: 50px;
text-align: left;
}
td.MISSCHIEN{
color: orange;
width: 100px;
background-color: #f07700;
height: 50px;
text-align: left;
}
td.op{
color: black;
width: 450px;
background-color: #ceDDce!important;
height: 50px;
text-align: left;
}
th{
color: black;
width: 40px;
background-color: #cecece;
height: 50px;
text-align: center;
}
th.op{
color: black;
width: 450px;
background-color: #cecece;
height: 50px;
text-align: center;
}
.a{
height: 25%;
cursor: pointer;
}
button{
width: 100%;
height: 100%;
margin: -5 auto -5 auto;
}
textarea {
height: 100%;
width: 100%;
}
.verwijder{
width: 10px;
height: auto;
background-color: #ffa8a8;
}
.space{
width: 20px;
height: auto;
}
.invoegen{
background-color: #6dbbdc;
width: 1434px;
padding: 5px;
margin: 5px;
}
.content{
background-color: #FFDD67;
width: 1500px; ;
padding: 0 5 0 5;
margin: 0 5 0 5;
}
.content table{
margin-bottom: 100px;
}
span{
text-decoration: underline;
}
select{
height: 90%;
}
</style>
<div class="content">
<?php
mysql_connect("localhost", "************", "*********") or die(mysql_error());
mysql_select_db("*********");
$sql = "SELECT ID, NAAM, CONTACT, TOEGEZEGD, bestuur1, bestuur2, bestuur3, bestuur4, bestuur5, VORM, PAKKET, KANGEFACTUREERD, GEFACTUREERD, AANTAL, POST, OPMERKING FROM `sponsoren` ORDER BY $field $sort";
$result = mysql_query($sql) or die(mysql_error());
echo'<table>';
while($row = mysql_fetch_array($result))
{
$BESTUUR1 = $row['bestuur1'];
$BESTUUR2 = $row['bestuur2'];
$BESTUUR3 = $row['bestuur3'];
$BESTUUR4 = $row['bestuur4'];
$BESTUUR5 = $row['bestuur5'];
if ($row['TOEGEZEGD'] == 'ja') {
$NewClass = "JA" ;
} elseif ($row['TOEGEZEGD'] == 'nee') {
$NewClass = "NEE";
} elseif ($row['TOEGEZEGD'] == 'misschien') {
$NewClass = "MISSCHIEN";
}
echo $NewClass;
echo'<tr>
<td><a href="full_table_row_results.php?ID='.$row['ID'].'">'.$row['ID'].'</a></td>
<td>'.$row['NAAM'].'</td>
<td>'.$row['CONTACT'].'</td>
<td >';
if($BESTUUR1 == 1){
echo "<div class='item'><label>Kk</label></div>";
};
if($BESTUUR2 == 1){
echo "<div class='item'><label>Rutger</label></div>";
};
if($BESTUUR3 == 1){
echo "<div class='item'><label>Toby</label></div>";
};
if($BESTUUR4 == 1){
echo "<div class='item'><label>Meijke</label></div>";
};
if($BESTUUR5 == 1){
echo "<div class='item'><label>Boele</label></div>";
}"</td>";
echo'<td class = "$NewClass">'.$row['TOEGEZEGD'].'</td>
<td class = \"$New$Class\">'.$row['VORM'].'</td>
<td><DIV CLASS="$NewClass">'.$row['PAKKET'].'</DIV></td>
<td>'.$row['KANGEFACTUREERD'].'</td>
<td>'.$row['GEFACTUREERD'].'</td>
<td>'.$row['AANTAL'].'</td>
<td>'.$row['POST'].'</td>
<td class = "op">'.$row['OPMERKING'].'</td>';
echo'</tr>';
}
echo'</table>';
?>
</div>
</body>
</html>