Roger
|
Posted: 07/20/2001, 6:23 AM |
|
Any idea how I can get a ListBox to list in the order I want.
Currently it is always alpha order.
On PHP/MySQL
--
Rgds
Roger Tng
|
|
|
Alexey Alexapolsky
|
Posted: 07/20/2001, 6:53 AM |
|
Click Listbox properties icon , fill in "Lookup SQL"
like this :
select id_field , name_field from table order by name_field
--
Alex
CC
Roger <roger@web4sme.net> wrote in message
news:9j9bci$46j$1@news.codecharge.com...
> Any idea how I can get a ListBox to list in the order I want.
> Currently it is always alpha order.
>
> On PHP/MySQL
> --
> Rgds
> Roger Tng
>
>
>
|
|
|
Roger
|
Posted: 07/22/2001, 12:30 PM |
|
Works like a charm.
--
Rgds
Roger Tng
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:9j9d4q$80p$1@news.codecharge.com...
> Click Listbox properties icon , fill in "Lookup SQL"
> like this :
>
> select id_field , name_field from table order by name_field
>
> --
> Alex
> CC
>
>
> Roger <roger@web4sme.net> wrote in message
>news:9j9bci$46j$1@news.codecharge.com...
> > Any idea how I can get a ListBox to list in the order I want.
> > Currently it is always alpha order.
> >
> > On PHP/MySQL
> > --
> > Rgds
> > Roger Tng
> >
> >
> >
>
>
|
|
|
|