drop-down list or any other way

[ramil]

Hi good day

So im VERY new to PHP(triad.. PHP, MySQL, Apache) and programming too. And im stuck on this

Please, can any1 provides me an script on this.

Three drop-down list filled up with data from three related tables. As the user selects the first , the second, and third drop-down changes accordingly.. or Any other way that gives me same results.

You know guys it badly needed in my page. Im tracking Local Government Units(LGUs) Applying for grants. Actually i have an application on this but its written in MS Access and for a change im trying to migrate to PHP (from scrath).

I have three tables in mysql namely: Region, Province, Municipality/City with attributes of the ff:
for Region
Reg Id
Reg Name

for Province
Reg Id
Prov Id
Prov Name
Prov Income
and
for Municipality
Reg Id
Prov Id
Mun Id
Mun Name
Mun Income

and one LGU Application tbl, where i insert these drop-down list(selected) with their submitted documents.

Thanks
🙂

[netizen]

This isn't a PHP issue entirely. PHP is server side, the behavior you are asking for is client side and would require a javascript. You could utilize php to create the js arrays that your actions would switch on.

I would do a google on "js dynamic forms".

Sorry I can't help you further. These forums are great to guide you in the right direction or help with existing scripts, but to write your script from the ground up is a bit much to ask.

[klansman]

also, the best way to learn is by doing it yourself.

[]

[ramil]

Thank you!!!

Hoping your comments and helps for my next postings, and pls.

Can u recommend some books that fits to newbie like me , right now im using PHP and MySQL Web Development by Luke Welling and Laura Thomson. Thanks

[klansman]

i'm sorry...

i do not use paper-books. everything i have learned in php+mysql was from online documents.

there are some at my website.

[]