Display Unique values in a drop down Menu

[kayne31]

Hello,

 

I am new to the forums scene so I appoligise if what I post is incorrect or in the wrong place but I hope someone can help me.

 

I am busy with creating a catalog page for a friend and I have created a drop down menu to select the product from I am filling this menu as follows:

 

<option value="<?php echo $row_Recordset1['Make']?>"><?php echo $row_Recordset1['Make']?></option>

          <?php

} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));

  $rows = mysql_num_rows($Recordset1);

  if($rows > 0) {

      mysql_data_seek($Recordset1, 0);

  $row_Recordset1 = mysql_fetch_assoc($Recordset1);

  }

?>

 

However this is only giving me all the values from make but I only want to display unique values How can I do this?

 

Thanks in advance

[jl5501]

You do not show your query to generate your record set, but if you have select distinct at the start, it will only show unique values.

[kayne31]

Hi,

 

See said I was new to this sort of thing is this what you needed to see?

 

mysql_select_db($database_*, $*);

$query_Recordset1 = "SELECT Make FROM Products ORDER BY Make ASC";

$Recordset1 = mysql_query($query_Recordset1, $*) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

$totalRows_Recordset1 = mysql_num_rows($Recordset1);

[manwhoeatsrats]

Make it so your Query is "SELECT DISTINCT"  instead of SELECT.

 

"SELECT DISTINCT" will make it so it will only pull a value type once.

[kayne31]

Thank you all very much now works just the way I want ti to

 

:D :D