Join query problem

[eluser]danmontgomery[/eluser]
The point is that you already have that information... All you have to do is check what's NULL when you get it. By trying to re-join the table you're only costing yourself a headache.

Code:

$if($row->elevator_id == NULL) {
  // Do some work on the client
} else {
  // Do some work on the elevator
}