title: Put 2 info from different cols in 1 dropdown menu
body: <p>I want to put 2 information in 1 drop-down menu. I'm doing a school system. So for classes drop-down menu, I would like to put [classname (year)] in the drop-down-menu. The information were in a same table but different cols. I can only manage to display the class id / class name only. </p>
  
  <pre><code> &lt;tr&gt;
    &lt;td&gt;Class&lt;/td&gt;
    &lt;td&gt;
      &lt;select name="classname" id="textbox"&gt;
       &lt;option&gt;---- Class Name   ------&lt;/option&gt;
         &lt;?php
           $class_name=mysql_query("SELECT * FROM class_tbl");
           while($row=mysql_fetch_array($class_name)){
         ?&gt;
       &lt;option value="&lt;?php echo $row['class_name'];?&gt;"&gt; &lt;?php echo $row['class_id'];?&gt; &lt;/option&gt;
         &lt;?php 
           }
         ?&gt;
      &lt;/select&gt;
     &lt;/td&gt;
   &lt;/tr&gt;
  </code></pre>