PHP check if DB entry is 1/0

Question

I want to check in my If-Statement if the status is 1(true) or 0(false). The value is stored in a mySQL DB with tinyint.

The following code returns an error:

if($zeile['STATUS']=='1')
  {
      echo "<td align='center'>true;</td>";
  }
  else{
      echo "<td align='center'>false;</td>"; 
  }

The error is:

Notice: Undefined index: STATUS in /home/u123210707/public_html/index.php on line 49'. line 49

is my If-statement

'Notice: Undefined index: STATUS in /home/u123210707/public_html/index.php on line 49'. line 49 is my If-statement — MegaCleptomaniac, Jul 23 '15 at 07:15
Please give us the code before the if statement... like the query and how you fetch the data... — Arjuna Wenzel, Jul 23 '15 at 07:16
you'll need to provide the query for this, as well as db schema. No way for a concrete/definite answer here. — Funk Forty Niner, Jul 23 '15 at 07:18

score 1 · Answer 1 · answered Jul 23 '15 at 07:27

1

if($zeile['STATUS'] > 0)
  {
/* whatever */
}

answered Jul 23 '15 at 07:27

Jeremy Board

score 0 · Answer 2 · answered Jul 23 '15 at 07:23

0

In your $zeile array there is no element like STATUS, that's why its give this error,

i think before if condition you must have to check array using print_r and check there is an element called STATUS.

answered Jul 23 '15 at 07:23

Nimish Mer

yeah I took STATUS from the wrong Table *shame* – MegaCleptomaniac Jul 23 '15 at 07:30

2 Answers2