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:

Code: ( text )$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.
Code: ( php )thanks, I had to change $query to $result - but other than that, it works perfectly.Glad it does. See ya.

Ronald