title: how to get label of selectbox in PHP by its value - Typo3
body: <p>Theres a selectbox in Typo3 backend of one of my plugins. The option values are 0,1,2,3... The option-name or label itself contains the Text: foo,bar,whatever,...</p>
  
  <p>Now whats saved in the DB is the value. But i need to show the label or name.
  The extension, plugin is set up with Kickstarter or its also ok for me to change something myself in files if needed.</p>
  
  <p>I know its possible to change the value from 0-x to its label. But i dont like it and i will just do it if theres no way to get the label, name.</p>
  
  <p>Someone knows how to get them based on the value of the option or its even possible?</p>
  
  <p>heres my php - $v['category'] is 0,1,2,3... from the selectbox:</p>
  
  <pre><code>    $res = $GLOBALS['TYPO3_DB']-&gt;exec_SELECTquery(
          '*', 
          'sometable',
          '',
          '',
          'title ASC',
          ''
      );
      while($row = $GLOBALS['TYPO3_DB']-&gt;sql_fetch_assoc($res)) {
          $projects[] = $row;
      }
  
      $content = '&lt;div class="projectlist"&gt;';
      foreach ($projects as $k =&gt; $v) {
          $content.= '&lt;div class="project-single"&gt;';
          $content.= $v['title'].' | '.$v['category'];
          $content.= '&lt;/div&gt;';
      }
      $content.= '&lt;/div&gt;';
  </code></pre>