What am I doing wrong???

I've added a calendar to a site, first requirement was 2 colors, so I created a database with dates. If the date is found the day on the calendar will show red, if it isn't in the table it shows green. All working great.
Now the requirements have changed and I need 3 colors, so I added a field to the database to indicate state (a,b or blank) how do I get it to fillthe color based on that extra field, I've tried everything and just cant get it to work... once I change the code it keeps looping to infinity instead of showing just one month...

Code:

<?php
## print only the number of weeks needed
for($row=1;$row<$wim+1;$row++)
{  
  echo "<tr height='60'>";  

  ## prints week (Sun to Sat)
  for($week=1;$week<8;$week++)  
  {  
    $ct++;  
    $value=mktime(0,0,0,$month,$ct-$dow,$year);  
    
    ## if $value is part of current month
    if (date("m",$value)==$month)  
    {  
      echo "
      <td align='center' class='body' width='85' valign='top'";
    ## check if current date is available
$dag = date("j",$value);
$query=mysql_query("select * from $db_table where YEAR = $year AND MONTH = $month AND DAY = $day");
## run query

$total = mysql_num_rows($query);

if ($total > 0 )
{
echo " bgcolor='#CC0000'";
}
else
{
   echo " bgcolor='#00AA00'";
}
  echo " >
        <div align='right'><b>".date("j",$value)."</a></b></div><br>
      </td>"; 
    }  
    ## print previous and next month dates, but grayed out
    else 
    { 
      echo "<td align='center' class='body' width='85' valign='top' 
bgcolor='#CCCCCC'><div 
align='right'><b>".date("j",$value)."</a></b></div><br></td>";
    }  
  }
  
  echo "</tr>";
}  


echo "</table>";  
?>

[Join us @ facebook]

If I understand what you ask you may change this :

Code:

<?php

$query=mysql_query("select * from $db_table where YEAR = $year AND MONTH = $month AND DAY = $day");
## run query

$total = mysql_num_rows($query);

if ($total > 0 )
{
echo " bgcolor='#CC0000'";
}
else
{
   echo " bgcolor='#00AA00'";
}
?>

to this :

Code:

<?php
$query=mysql_query("select `state` from $db_table where YEAR = $year AND MONTH = $month AND DAY = $day LIMIT 1");
## run query

if (mysql_num_rows($query) > 0 )
{
$rec = mysql_fetch_array($query);
if ( $rec[ 'state' ] == 'a' )
{
echo " bgcolor='#CC0000'";
} else {
echo " bgcolor='#xxxxxx'";
}
}
else
{
   echo " bgcolor='#00AA00'";
}

Change the `state` field in the mySql statement to whatever you have named the field that keeps the state indicator.

I've also added a LIMIT to your statement which will make the query faster

Thats exactly what I needed! Thanks Nikolas!

[Join us @ facebook]

You are welcome

[Guest]

[37.937]

Yahoo crawler, adsense, Googlebot, Baidu Spider, Msnbot, Gigabot