Unique values in Dropdown menu from SQL Server

[Odubz]

Hello,

I was wondering does anyone have an idea how to make a dropdown menu that dosent repeat values from the SQL Server? Perferably using a while loop. I was thinking of camparing the set values with the new values as it loops through them but im not sure.

-Thanks

[diafol]

Are you sure you're using pHp? SQL Server 'usually' used with ASP.

[Brian Swan]

What is the query you are using to pull data from the database? (Are you already using the UNIQUE clause?)

-Brian

[Odubz]

Heh yea im using SQL Server alright. Its using that plugin from microsoft (sqlsrv). Im actually not using the UNIQUE clause. Here is my code with the query in it:

$sql = "SELECT MaterialLot# FROM $Tower WHERE mainProc='$mainProc'";
		  $result = sqlsrv_query($conn,$sql) or die("Couldn't execut query");
	
		  echo "<form action='cutting.php' method='POST'>";
		  echo "<select name='LotSelect'><option> Choose </option>";

		  
		  while($data=sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)){
			echo "<option value=".$data['MaterialLot#'].">".$data['MaterialLot#']."</option>";
		
		  }
	  	  echo "<input type='hidden' name='cut' value='prevLot'>";
		  echo "<input type='submit' value='Select Pallet'></select></form></br>";

$Tower and $mainProc are from session variables.

[diafol]

'SELECT DISTINCT' is what you probably want.

[Odubz]

Haha nice! I kind of feel like a fool, I had a feeling it would be a keyword in the query...Should have looked at the docs closer. Thanks alot Ardav