Dynamic HTML/PHP/MySQL Form

coool's Avatar
Go4Expert Member
Hi everyone,

I really need a help.. I feel kind of lost somewhere ! .. I have a deadline on this coming Monday.. - 4 days left

2 forms at the same page
__________________________
Form 1:

I have a list called available_fields, it has the name of my table's columns in the database - I already retrieve the content of this list from my database (multiple selection can be done here)

now I need a button that moves the selected items from my available_ fields list TO selected_fields list.. also a button to do the opposite (move back the elements)

now! what's in the selected_fields list should be used later in a MySQL query as fields of my result table
__________________________
Form 2

I should have a counter here of number of conditions (criterias) of our query
I have a drop down list that have (AND) (OR) .. logic !
I have a drop down list of brackets such as ( (( ((( (((( (((((
I have a drop down list with all fields again ( but a dropDownList not a list ) - one selection only
I have a drop down list of comparisions such as ( = != InList NotInList .. etc )
I should have a list of values of the exact field selected ( this is a dependent list on which field has been selected)
I have a drop down list of brackets such as ) )) ))) )))) )))))
then a botton allowing the user to delete the condition
at the end of this form there should be a button to add another criteria (condition)

now! the result of this form should be used later in a MySQL query as conditions on my result table
__________________________
then I should have something like this:
SELECT _ _ -result of form 1 _ _ FROM tableName WHERE _ _ result of form 2_ _)
at the end I should display the result of this query in a different page
__________________________
please help!

at lease.. I need a small clear example..

P.S. I have a pic of the form I need to program.. but could not attached it here.. send me an email (co.ooo.ol@hotmail.com) if you want to see it.. I can e-mail you the form picture..
0
coool's Avatar
Go4Expert Member
here's an image of a form I'm planning to code

http://img502.imageshack.us/my.php?image=formfb7.jpg
0
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Show me the pic, I might get a better idea of what you want!
0
coool's Avatar
Go4Expert Member
I just did..
0
pradeep's Avatar, Join Date: Apr 2005
Team Leader
The 1st form is easy, you'll find a lot of free JavaScript code to move items between select boxes!
0
coool's Avatar
Go4Expert Member
Can you please post a way to do that using javascript ! .. so everyone reading this post will be benefited..

or just direct me to some links that have the free code to do the process ! ..

thanks in advace
0
pradeep's Avatar, Join Date: Apr 2005
Team Leader
This one will help you http://www.mattkruse.com/javascript/selectbox/
0
coool's Avatar
Go4Expert Member
Thanks alot.. this is really useful