Jump to content

Display data from mysql column only once


elcabron10

Recommended Posts

I am facing this problem, everything works perfect except it shows all the data form the mysql column(DeptName). What i want is to only display the data once. eg. if the column contains two same name like (IT Department) it must only display one name (IT Department) in the dropdown list. Please advise.

<tr>
              <td>Department</td>
              <td>
				<?php
					mysql_connect('localhost','root','admin') or die ('Could not fetch data from database.');
					mysql_select_db('dctvmaindb') or die ('Connection could not be established.');
					
					$query = mysql_query("SELECT DeptName FROM tbldepartmentlist");
					
					$options = "";
					
					while($result=mysql_fetch_array($query))
					{
					$options .= '<option value= "' .$result['DeptName'].'">' .$result['DeptName'].'</option>';
					}
				  ?>
				<select id="Department" name="Department">
                  <?php
					echo $options;
				  ?>
                </select>
				</td>
            </tr>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.