Re: Populating HTML List boxes From DB
| From: | Shaun | Date: | Mon, 16 Apr 2001 23:53:40 +0000 |
| Subject: | Re: Populating HTML List boxes From DB | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-48859@lists.php.net to get a copy of this message | ||
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:Jason.Murray@melbourneit.com.au]
> 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