Need switch for multiple database fields

[geosite]

Imagine a database table with the fields URL, PX, IVR, ER, FW, JB and SM. URL contains people's names. Each cell in each of the other fields can contain one of two values - the name of the field or NULL:

URL | PX | IVR | ER | FW | JB | SM

(1) Joe_White | NULL | NULL | NULL | NULL | NULL | SM
(2) Cat_Smith | PX | IVR | ER | FW | JB | SM
(3) Dan_White | PX | NULL | NULL | NULL | NULL | NULL
(4) Joe_Cool | NULL | IVR | NULL | NULL | NULL | NULL
(5) Tom_Brown | NULL | NULL | ER | FW | NULL | NULL

There's one more key to the puzzle: The script I want to write will vary depending on the local website. For example, let's say we're visiting http://www.SM.com, identified by $MySiteID = 'SM'.

Now suppose you have a query, followed by the following echo statements:

$PX (equals the contents of the cell on field PX that correlates with the name in Field URL)

$IVR (displays the contents of the cell on field IVR that correlates with the URL)

$ER, $FW, $JB & $SM follow the same pattern.

Can someone show me how to write a switch(es) or IF statement(s) that does the following?:

1. Display "SM" if the field SM contains the value SM (rows 1 and 2 in the example above)

2. If SM is NULL, and there's just one entry in another field, display that value (e.g. "PX" in the third row in the above example or "IVR" in the next row.

3. If there are values in two or more fields, none of which equal $MySiteID ( SM, in this example), display "Multiple Choice" (the last row in the example above).

Thanks.

[Dan Grossman]

while ($row = mysql_fetch_array($query_result)) {

  //Check if the column corresponding to the local website is not empty
  if (!empty($row[$MySiteID])) {
    echo $MySiteID;
  } else {
    
    //That column was empty, so look for values in other columns of the row

    $foundFields = array();
    $possibleFields = array('PX', 'IVR', 'ER', 'FW', 'JB', 'SM');
    foreach ($possibleFields as $field) {
      if (!empty($row[$field])) {
        $foundFields[] = $row[$field];
      }
    }

    if (count($foundFields) == 0) {
      echo 'None found';
    } elseif (count($foundFields) == 1) {
      echo $foundFields[0];
    } else {
      echo 'Multiple Choices: ' . implode(', ', $foundFields);
    }

  }

} 

You have a very strange database.

[geosite]

Thanks, Dan.

[geosite]

You have a very strange database.

That's the one thing I like about MySQL; if you can't figure out the right way to do something, you can always use the bigger hammer approach. I wish PHP was that forgiving.