change text color depending on date/search

Lorik

Here's my query
$query = "SELECT * FROM ourfin WHERE (nextyearend < '$srch' OR nextquarter < '$srch' OR nextpfs < '$srch' OR nextbank < '$srch') AND producer='Lori' ORDER BY client";

A chart is then shown with 4 fields as long as any of these dates come before the date entered into the form. I would like that date which is past - the one that caused the record to show up - to be identifiable - either bold or different font color or something.

Any idea?

jeremuck

$query = "SELECT * FROM ourfin WHERE (nextyearend < '$srch' OR nextquarter < '$srch' OR nextpfs < '$srch' OR nextbank < '$srch') AND producer='Lori' ORDER BY client";

There are a few options.
1.)You could split up the queries. Then test which one it was that worked.

2.)Or you could test each field before you print it.

1 might be considered wasteful of resources.
2 would save resources and it would be easier to implement, I think.

if($queryFieldAboutToBePrinted < $srch)
{
$HTMLOUTPUT .= "<b>" . $queryField.... . "</b>";
}

That's I would do it, based on the information you gave us.

Lorik

Sorry but I'm really crap at this stuff - I get what you're saying - just not sure how I should do it -
do I set up a query for each field separately?

jowatkins

$fields = mysql_num_fields ($yourquery)

foreach ($fields as $item)
{
  $field=mysql_fetch_object($yourquery)
  if($queryFieldAboutToBePrinted < $srch) 
  { 
    echo "<b>$field</b>";  

  } 
  else
  {
    echo "$field";  

}

Sorry, it's a bit quick so you may need to play with it, but the idea is there

jeremuck

I'm gonna give you a function I use. I'll even modify it to do exactly what you want. (if what you want is printing a table).
BTW, this also includes a checkbox in the first column, because I use it to select records to edit. I'll let you remove that yourself, if you want to use it. Other than that, you should be able to plug this in "as is".

function PrintSearchResults($results, $srch)
{
	print "<table border=\"0\" cellpadding=\"5\">\n<tr>";
	print "<th>Edit</th>";
	if($Field = mysql_fetch_field($results))
	{
		$CheckBoxName = $Field->table . "Index";

}

do
{
	print "<th>" . $Field->name . "</th>\n\t";
}	while($Field = mysql_fetch_field($results));

print "</tr>\n";
while($row = mysql_fetch_array($results, MYSQL_ASSOC))
{
	print "<tr>\n";

	print "\t<td bgColor=#DDDDDD><input type=radio name=\"" . $CheckBoxName . "\" value=" .
	$row['Index'] . "></td>\n";

	foreach($row as $value)
	{

//THIS IS IT RIGHT HERE.

if($value < $srch)
{
print "\t<td bgColor=#CCDDDD><b>" . $value . "</b></td>\n";
}
else
{
print "\t<td bgColor=#DDDDDD>" . $value . "</td>\n";
}


	}

	print "</tr>\n";

}

print "</table>\n";

}