dumbstruck again - dynamic form handling

[ruido]

hi all,

I'm stuck somehow...

I need to change select fields in a form dynamically after the values of the first select were checked against a db.

I have a form with let's say 2 select fields, 'group' and 'username'.

I get the option fields for 'group' from a mysql query - that's working ok.
Here comes the crux:

I want the 'username' options to contain just the names of the selected group. (I get the usernames from the db, too)

The SQL statements are not the problem here, it's about how to
properly pass the 'group' variable to the 'username' select.

I know JavaScript event handlers are not working here (yeh, client-side) , but is there something like OnChange in php?

if some guru could plz enlighten me ...

thx in advance

Marc

[malbera]

try OnChange to the 'group' select
it it changes, redirect to php_self?group=group_selected
hope that helps

[ruido]

hmmm, strange, now I'm getting a mysql error:

Duplicate entry '' for key 1

Funny thing is, I have no keys in my tables, there are no duplicate entries, the value is still empty and I'm just doing a
SELECT...

😕