RE: [PHP] Populating HTML List boxes From DB

[Peter Houchin]

Thanks Jason... I've used SELECT DISTINCT ... now i doubt this has anything to do with 
SELECT DISTINCT as such but for some reason its only displaying the last vaule entered

<select name="device">
<?php
  $query ="SELECT DISTINCT device FROM 3backup ORDER BY device";
  $rs =mysql_query($query);
  $device = mysql_result($rs, 'device');
  while($row = mysql_fetch_object($rs)){
    echo '<option value="';
    echo $device;
    echo '">';
    echo $device;
        echo '</option>\n';
  }
?>
</select>

Any suggestions? 

Peter
-----Original Message-----
From: Jason Murray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 11:12 AM
To: 'Peter Houchin'; Php-General@Lists. Php. Net
Subject: RE: [PHP] Populating HTML List boxes From DB


> say in my db i have multiple values that are the same as well 
> as different values... how can i restrict it to showing each 
> value just once?

Sounds like you want a "SELECT DISTINCT".

You might want to have a look at www.sqlcourse.com.

Jason