Try using $row->device instead of $divice in your while statement.
Brett
> 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
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
