CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

 ListBox filter duplicates entries

Print topic Send  topic

Author Message
muebelacker

Posts: 5
Posted: 01/28/2008, 3:47 AM

Hello All,

i use a table to fill a ListBox. The column categories contains for example Level1 and this entry maybe 5 times.

How can i handle that the entry Level1 is only one times in the Listbox and not 5 times.

br
Mathias
View profile  Send private message
wkempees
Posted: 01/28/2008, 5:00 AM

Change the Listbox's SELECT statement
from
SELECT id, text FROM table
to
SELECT id, DISTINCT(text) from table





"muebelacker" <muebelacker@forum.codecharge> schreef in bericht
news:5479dc0b926484@news.codecharge.com...
> Hello All,
>
> i use a table to fill a ListBox. The column categories contains for
> example
> Level1 and this entry maybe 5 times.
>
> How can i handle that the entry Level1 is only one times in the Listbox
> and not
> 5 times.
>
> br
> Mathias
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

muebelacker

Posts: 5
Posted: 01/28/2008, 5:49 AM

Thanks that answered my question and it works fine.

br
Mathias
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.