title: Not Submitted Blank Results mysql php
body: <p>Hello there I was wondering if I could have some help solving this (maybe) easy problem.
  The code below works fine and prints all submitted fields, but there are 3 other where the user submitted blank, because its not required. These I would like to print as NOT FILLED. Given my level of programming perhaps I need some help because I have tried quite a few ways and no success. thank you for your most important help.</p>
  
  <pre><code>&lt;?php
    mysql_connect ("thehost","user","password") or die ('Cannot connect to MySQL: ' .   mysql_error());
  mysql_select_db ("database") or die ('Cannot connect to the database: ' . mysql_error());
  echo '&lt;table&gt;';
  $query = mysql_query("SELECT column FROM table WHERE field='11'") or die ('Query is invalid: ' . mysql_error());
  
  while ($row = mysql_fetch_array($query)) {
      echo'&lt;tr&gt;&lt;td&gt;';
      echo '&lt;td&gt;'.($row['value']!="")?$row['value']:"Not Filled".'&lt;/td&gt;';  
      echo '&lt;/td&gt;&lt;/tr&gt;';
  }       
  echo '&lt;/table&gt;';
  ?&gt;
  &lt;!--HTML dom--&gt;
  &lt;table&gt;
  &lt;tr&gt;
  &lt;td&gt;result_1&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
  &lt;td&gt; result_2&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
  &lt;td&gt; result_3&lt;/td&gt;
  &lt;/tr&gt;
  &lt;tr&gt;
  &lt;td&gt; result_4&lt;/td&gt;
  &lt;/tr&gt;
  &lt;/table&gt;
  </code></pre>