mysql query changing font color

[petrakid]

I have a table called oth_recruitment

In the table are 10 fields. Each field will have only 1 entry: Open or Closed.

On my website, I have the following code:

       <?php
 
    include 'admin/config.php';
    include 'admin/opendb.php';
 
    $query  = "SELECT druid FROM oth_recruitment";
    $result = mysql_query($query);
 
        if ($result == 'Open')
        {
            echo "<font color=\"#00FF00\">Open</font>";
        } else
        {
            echo "<font color=\"#FF0000\">Closed</font>";
        }
    ?> 

When the query runs, and it finds "Open" in the field druid, I want word "Open" to show on the webpage, and I want it to be green. When the word "Closed" is found, I want the word "Closed" to show in red. I'm doing something wrong here, obviously, because no matter what I change the value to in the table, it always displays "Closed".

[ronverdonk]

$query only contains the handle to your result set. You have to read or browse through the result set. Since you have 1 column result only you could use mysql_result, but I will show how to read an entire row and how to address the individual columns via an associated (row) array, e.g.
[php]
while ($row = mysql_fetch_ass oc($query)) {
if ($row['druid'] == 'Open')
echo "<font color=\"#00FF00 \">Open</font>";
else
echo "<font color=\"#FF0000 \">Closed</font>";
//
// process other columns in the row
//
}
[/php]

Ronald

[petrakid]

thanks, I had to change $query to $result - but other than that, it works perfectly.

[ronverdonk]

Glad it does. See ya.

Ronald