Hi,
Here is my codings.Pl help me to change the bgcolor when the value in td11
becomes 0.
[PHP]<?
session_start() ;
?>
[/PHP][HTML]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<!--<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />-->
<!--<meta http-equiv="refresh" content="3" />-->
<title>Live Campaign Report</title>
<link href="main.css" rel="stylesheet " type="text/css" />
<style type="text/css">
.odd{background-color:#acbdee;}
.even{backgroun d-color:#cddeff;}
</style>
</head>
<body onload="alterna te('thetable')" >
<div id="header"><h2 ><img src="images/ptlogo.gif" /></h2>
<h1><img src="images/pt1.gif" width="870px" height="120px" /></h1>
</div
><DIV id=content-wrap>
<DIV id=content>
<DIV>
<H1 class="h1">Live Campaign Report</H1></DIV>
<STYLE>A {
TEXT-DECORATION: none
}
A:hover {
TEXT-DECORATION: none
}
A:visited {
TEXT-DECORATION: none
}
A:link {
TEXT-DECORATION: none
}
</STYLE>
[/HTML]
[PHP]<?PHP
include("conn.p hp");
$sel= mysql_select_db ("dialer");
include("functi on.php");
$fdate = date('d-m-Y');
$tdate = date('d-m-Y');
$tables=$_GET['tables'];
/* $fdate = $_POST['fdate'];
$tdate = $_POST['tdate'];
$submit = $_POST{'submit' };*/
?>
[/PHP]
[HTML]<body>
</div>
<DIV id=content-wrap>
<DIV id=content>
<br /><center>
<td colspan="4" align="center" >Select Campaign:
<form name="myform" method="POST" action="manage1 _campaign1.php" >
[/HTML][PHP]<?php
$list = mysql_list_tabl es ("dialer");
echo" &nbs p; <selec t name='tables' value=\'\' onChange='table pick();'>";
$i = 0;
//echo "<option value=''>Select Table</option>";
if($_GET['tables'])
{
echo "<option value='$tables' selected>$table s</option>";
}
while ($i < mysql_num_rows ($list)) {
$tb_names[$i] = mysql_tablename ($list, $i);
echo"<option value='$tb_name s[$i]'>$tb_names[$i]</option>";
$_SESSION['tables']=$_GET['tables'];
$i++;
}
echo "</select>";
?>
</form>
<?php
//echo $submit."<br>";
$fdate1 = explode("-",$fdate);
//print_r $fdate1;
$fdate3 = (strlen($fdate1[1]) == '1') ? "0".$fdate1[1] :$fdate1[1] ;
$fdate4 = (strlen($fdate1[0]) == '1') ? "0".$fdate1[0] :$fdate1[0] ;
$fdates = $fdate1[2]."-".$fdate3."-".$fdate4;
if($fdate == $tdate)
{
$tdates1 = mktime(0,0,0,$f date3,$fdate4+1 ,$fdate1[2]);
$tdates=date("Y-m-d", $tdates1);
// echo "Tomorrow is ".$tdates;
} else{
$tdate1 = explode("-",$tdate);
$tdate3 = (strlen($tdate1[1]) == '1') ? "0".$tdate1[1] :$tdate1[1] ;
$tdate4 = (strlen($tdate1[0]) == '1') ? "0".$tdate1[0] :$tdate1[0] ;
$tdates = $tdate1[2]."-".$tdate3."-".$tdate4;
}
//echo "<table cellspacing=5 cellpadding=5 border=0 align=center><t r class=h3><td>Fr om Date </td></tr>";
echo "<tr> <td> </td></tr></table>
<table border=1 width=95% align=center id='thetable'>
<tr><td class='th'>Fres hRecord</td></td><td class='th'>Sale </td>
<td class='th'>Call Back</td><td class='th'>Hang upAfterListen</td>
<td class='th'>Answ eringMachine</td><td class='th'> Busy</td>
<td class='th'>NotI nterested</td><td class='th'>Over Phone</td>
<td class='th'>Move Away</td><td class='th'>Lang uageBarrier</td>
<td class='th'>Cont act</td></tr>";
if($fdate != $tdate){
}
if ($tables=$table s)
{
$td1 = mysql_query("SE LECT count(*) FROM $tables where disposition ='1'");
//$td1 = mysql_query("SE LECT count(*) FROM asterisk.cdr where calldate ='$fdates' and length(src) =10 and lastapp <>'v%'");
$td11 = mysql_fetch_row ($td1);
$td2 = mysql_query("SE LECT count(*) FROM $tables where lastupdated >='$fdates' and disposition ='12'");
//$td1 = mysql_query("SE LECT count(*) FROM asterisk.cdr where calldate ='$fdates' and length(src) =10 and lastapp <>'v%'");
$td22 = mysql_fetch_row ($td2);
$td3 = mysql_query("SE LECT count(*) FROM $tables where lastupdated >='$fdates' and disposition ='0'");
//$td1 = mysql_query("SE LECT count(*) FROM asterisk.cdr where calldate ='$fdates' and length(src) =10 and lastapp <>'v%'");
$td33= mysql_fetch_row ($td3);
$td4 = mysql_query("SE LECT count(*) FROM $tables where lastupdated >='$fdates' and disposition ='2'");
//$td1 = mysql_query("SE LECT count(*) FROM asterisk.cdr where calldate ='$fdates' and length(src) =10 and lastapp <>'v%'");
$td44 = mysql_fetch_row ($td4);
$td5 = mysql_query("SE LECT count(*) FROM $tables where lastupdated >='$fdates' and disposition ='3'");
//$td1 = mysql_query("SE LECT count(*) FROM asterisk.cdr where calldate ='$fdates' and length(src) =10 and lastapp <>'v%'");
$td55 = mysql_fetch_row ($td5);
$td6 = mysql_query("SE LECT count(*) FROM $tables where lastupdated >='$fdates' and disposition ='4'");
//$td1 = mysql_query("SE LECT count(*) FROM asterisk.cdr where calldate ='$fdates' and length(src) =10 and lastapp <>'v%'");
$td66 = mysql_fetch_row ($td6);
$td7 = mysql_query("SE LECT count(*) FROM $tables where lastupdated >='$fdates' and disposition ='5'");
//$td1 = mysql_query("SE LECT count(*) FROM asterisk.cdr where calldate ='$fdates' and length(src) =10 and lastapp <>'v%'");
$td77 = mysql_fetch_row ($td7);
$td8 = mysql_query("SE LECT count(*) FROM $tables where lastupdated >='$fdates' and disposition ='6'");
//$td1 = mysql_query("SE LECT count(*) FROM asterisk.cdr where calldate ='$fdates' and length(src) =10 and lastapp <>'v%'");
$td88 = mysql_fetch_row ($td8);
$td9 = mysql_query("SE LECT count(*) FROM $tables where lastupdated >='$fdates' and disposition ='7'");
//$td1 = mysql_query("SE LECT count(*) FROM asterisk.cdr where calldate ='$fdates' and length(src) =10 and lastapp <>'v%'");
$td99 = mysql_fetch_row ($td9);
$td10 = mysql_query("SE LECT count(*) FROM $tables where lastupdated >='$fdates' and disposition ='9'");
//$td1 = mysql_query("SE LECT count(*) FROM asterisk.cdr where calldate ='$fdates' and length(src) =10 and lastapp <>'v%'");
$td1010 = mysql_fetch_row ($td10);
$td112 = mysql_query("SE LECT count(*) FROM $tables where lastupdated >='$fdates' and disposition ='11'");
//$td1 = mysql_query("SE LECT count(*) FROM asterisk.cdr where calldate ='$fdates' and length(src) =10 and lastapp <>'v%'");
$td1111 = mysql_fetch_row ($td112);
echo "<tr>
if($td11[0]==0)
{
echo"<td bgcolor="red">$ td11[0]</td>";
}
else
{
echo"<td bgcolor="green" >$td11[0]</td>";
}
<td>$td22[0]</td>
<td>$td33[0]</td>
<td>$td44[0]</td>
<td>$td55[0]</td>
<td>$td66[0]</td>
<td>$td77[0]</td>
<td>$td88[0]</td>
<td>$td99[0]</td>
<td>$td1010[0]</td>
<td>$td1111[0]</td></tr>";
}
?>[/PHP]
[HTML]</td>
<tr>
</tr>
</table>
</center>
</DIV>
</DIV><br />
<div id="footer">
<hr />
<table border=0 cellspacing=0 cellpadding=0>
<tr><td align="left">
<table width="400px">
<tr>
<td><a href="live_repo rts.php"><img src="images/back.jpg" /></a></td>
</tr>
</table>
</td>
<td>
<table width="450px">
<tr><td align="left">&c opy PeopleTech</td></tr>
</table>
</td>
<td>
<table><tr>
<td align="right">< a href="home.php" ><img src="images/home.jpg" /></a></td></tr></table>
</td>
</tr>
</table>
</div>
<script language="javas cript">
var sURL = unescape(window .location.pathn ame);
function tablepick(){
var val=document.my form.tables.val ue;
//document.form1. client.value = document.form1. store_id.value;
var ul =sURL +'?tables='+ val;
window.location .href =ul ;
//alert('hai');
}
function alternate(id){
if(document.get ElementsByTagNa me){
var table = document.getEle mentById(id);
var rows = table.getElemen tsByTagName("tr ");
for(i = 0; i < rows.length; i++){
//manipulate rows
if(i % 2 == 0){
rows[i].className = "even";
}else{
rows[i].className = "odd";
}
}
}
}
</script>
<script type="text/javascript">
function reFresh() {
location.reload (true)
}
window.setInter val("reFresh()" ,1000);
</script>
</body>
</html>[/HTML]
Suguna
15
