Posted by Manuel Lemos on 07/09/07 05:16

Viva,

on 07/02/2007 08:53 AM geshan said the following:
> Hello all,
> I'm having trouble populating a select box as per the selection of
> above select box.Its like level 2 select box depends on the value of
> level 1 box. Both the boxes values come from a mysql database. I tried
> to use AJAX, Jquery and JSON but I can send only string values I want
> to send the id of the records (int) which are numbers please help.

Take a look at this PHP forms class. It comes with a plug-in that can
link select inputs and even can dynamically retrieve a new set of option
from a MySQL database using AJAX to retrieve the options with your PHP
script.

Here you can see a demo:
http://www.meta-language.net/forms-examples.html?example=test_linked_select

Here you can see a tutorial video:
http://www.phpclasses.org/browse/video/1/package/1/section/plugin-linked-select.html

You can download the forms class and all plug-ins here:
http://www.phpclasses.org/formsgeneration

--

Regards,
Manuel Lemos

Metastorage - Data object relational mapping layer generator
http://www.metastorage.net/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

[Back to original message]