this
while($row = mysql_fetch_object($rs)){
echo '<option value="';
echo $device;
echo '">';
echo $device;
echo '</option>\n';
}
should be
$query ="SELECT DISTINCT device FROM 3backup ORDER BY device";
$rs =mysql_query($query);
while($row = mysql_fetch_row($rs)){
echo '<option value="';
echo $row[0];
echo '">';
echo $row[0];
echo '</option>\n';
}
of course this is just one of many ways to do it
-- Shaun
On Monday 16 April 2001 20:48, Peter Houchin wrote:
> 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]
