[Resolved] Different array settings depending on a MySQL value

jonnyboy

I need to change the color on certain output in an array if a value in a certain table is = true.

I am not quite sure where to start. I realise that it has to be done in the PHP script, but I havent done much "if or else" stuff yet.

Any help greatly appreciated.

Thanks

Jon

paulnaj

Give us some more info ...

Show us your code to extract the record (change field/table names, if you want).
What 'certain output'? Is it a TD or ...
Are they're many elements to change?
How many diffferent colours?

jonnyboy

Thanks for your respose

I want to test on another field in the table $log_assign. Initially I post NULL to it.

While the row has the field $log_assign with a value of NULL in it, I want to display the whole row in the array red.

Code as follows...

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
<link rel="stylesheet" type="text/css" href="../helpdesk/styles/test.css" title="dev style">
</head>

<h2>Calls Logged by Date</h2>
<?php

//include 'db.inc';
//include 'error.inc';

$query = "SELECT *, TO_DAYS(CURRENT_TIMESTAMP) - TO_DAYS(log_stamp)
AS date
FROM call_logger
WHERE log_status LIKE 'open'  

ORDER by log_stamp DESC";

//Open a connection to the DBMS
if (!($connection = @ mysql_connect($hostname,
   				  	  			    $username,
									$password)))
die("Could not connect to database");

if (!mysql_select_db("helpdesk", $connection))
    showerror();

//Run query created above on the database through the connection
if (!($result = @ mysql_query ($query, $connection)))
   showerror();

// Find out how many rows are available
   $rowsFound = @ mysql_num_rows($result);

echo "\n<table border=\"0\">";

// Output the number of open calls first 
echo "\n<tr>\n\t<th bgcolor=\"white\" width=\"100px\" align=\"left\">" .
     "<font color=\"#6699FF\">" .
     "$rowsFound <u>Open</u> Calls";
	 "</font></tr>\n\n\t";

//Print heading for the Creator
echo "\n<tr>\n\t<th bgcolor=\"white\" width=\"120px\" align=\"left\">" .
     "<font color=\"#666666\">" .
	 "<b>Creator</b>" . 
	 "</font></b></td>\n";

//Print heading for the Department
echo "\n\n\t<th bgcolor=\"white\" width=\"50px\" align=\"left\">" .
     "<font color=\"#666666\">" .
	 "<b>Dept.</b>" . 
	 "</font></b></td>\n";

//Print heading for the Title
echo "\n\n\t<th bgcolor=\"white\" width=\"400px\" align=\"left\">" .
     "<font color=\"#666666\">" .
	 "<b>Title</b>" . 
	 "</font></b></td>\n";

//Print heading for the Status
echo "\n\n\t<th bgcolor=\"white\" width=\"50px\" align=\"left\">" .
     "<center><font color=\"#666666\">" .
	 "<b>Status </b>" . 
	 "</font></b></td></center>\n";

//Print the heading for Number of days open
echo "\n\n\t<th bgcolor=\"white\" width=\"65px\" align=\"left\">" .
     "<center><font color=\"#666666\">" .
	 "<b>Days Open</b>" .
	 "</font></b></td></center>\n";

//Print the heading for log number
echo "\n\n\t<th bgcolor=\"white\" width=\"50px\" align=\"right\">" .
	 "<center><font color=\"#666666\">" .
	 "<b>Log No.</b>" .
	 "</td></center>\n";

//Process the new messages
while ($row = @ mysql_fetch_array($result)) 

{

//Print output for the log creator
echo "\n<tr>\n\t<td bgcolor=\"white\">" .
     "<font color=\"#666666\">" .
	  $row["log_creator" ] . 
	 "</font></b></td>\n";

//Print output for the department
echo "\n\n\t<td bgcolor=\"white\">" .
     "<font color=\"#666666\">" .
	  $row["dept" ] . 
	 "</font></b></td>\n";

//Print output for the log title
echo "\n\n\t<td bgcolor=\"white\">" .
     "<font color=\"#666666\">" .
	  $row["log_title" ] . 
	 "</font></b></td>\n";

//Print output for the log status
echo "\n\n\t<td bgcolor=\"white\">" .
     "<center><font color=\"#666666\">" .
	  $row["log_status" ] . 
	 "</font></b></td></center>\n";

//Print output for the log date
echo "\n\n\t<td bgcolor=\"white\">" .
     "<center><font color=\"#666666\">" .
	  $row["date" ] . 
	 "</font></b></td></center>\n";

//Print output for the log_id
echo "\n\n\t<td bgcolor=\"white\" align=\"right\">" .
     "<center><font color=\"#666666\">" .
	  $row["log_id" ] . 
	 "</font></b></td></center>\n";

//Blank row for presentation
}
if(!mysql_close($connection))
//showerror();


?>
</body>
</html>

paulnaj

Nearly there.

If I get you right, you're saying:
1) There's another field in the table called log_assign.
2) For each row, if the value of log_assign is NULL then you want
the colour to be red, otherwise a default colour.

A couple more questions ...
1) What are the other options for log_assign, apart from NULL?
2) Change the colour of what to red ... the text colour or the
background colour?

jonnyboy

Thanks.

Yes. Correct on requirement.

The other values will be two names. For example there would be three possible values...'NULL','NAME1','NAME2'

If the value of 'NULL' is in $log_assign I would like the text to be red.

Jonathan

paulnaj

Ok, here we go.

In general, it's better to try and get as much from MySQL
as possible, as it is a lot faster than PHP!! So, we choose
the colour right in the SELECT clause itself. So no need for
any if statements anyway!

First of all, your SQL should now read ...

$query = "
SELECT *,
  TO_DAYS(CURRENT_TIMESTAMP) - TO_DAYS(log_stamp) AS date,
  IF(ISNULL(log_assign), 'FF0000', '666666') as txt_col
FROM call_logger
WHERE log_status LIKE 'open'
ORDER by log_stamp DESC
";

Then, goto the '//Process the new messages ' section.
In every TD replace the numbers only of the
font color value from ...

666666

... to exactly...

".$row["txt_col"]."

... including all surrounding double-quotes.

It should look like ...

//Process the new messages
while ($row = @ mysql_fetch_array($result))

{


//Print output for the log creator
echo "\n<tr>\n\t<td bgcolor=\"white\">" .
     "<font color=\"#".$row["txt_col"]."\">" .
      $row["log_creator" ] .
     "</font></b></td>\n";

//Print output for the department
echo "\n\n\t<td bgcolor=\"white\">" .
     "<font color=\"#".$row["txt_col"]."\">" .
      $row["dept" ] .
     "</font></b></td>\n";

//Print output for the log title
echo "\n\n\t<td bgcolor=\"white\">" .
     "<font color=\"#".$row["txt_col"]."\">" .
      $row["log_title" ] .
     "</font></b></td>\n";

//Print output for the log status
echo "\n\n\t<td bgcolor=\"white\">" .
     "<center><font color=\"#".$row["txt_col"]."\">" .
      $row["log_status" ] .
     "</font></b></td></center>\n";

//Print output for the log date
echo "\n\n\t<td bgcolor=\"white\">" .
     "<center><font color=\"#".$row["txt_col"]."\">" .
      $row["date" ] .
     "</font></b></td></center>\n";

//Print output for the log_id
echo "\n\n\t<td bgcolor=\"white\" align=\"right\">" .
     "<center><font color=\"#".$row["txt_col"]."\">" .
      $row["log_id" ] .
     "</font></b></td></center>\n";

Let me know how you get on.

jonnyboy

This works. Brilliant!

Thanks very much for your help.

Jonathan

paulnaj

It's a pleasure.

Remember to mark the thread [resolved] ... there's a link to do this below the posts.