Go4Expert

Go4Expert (http://www.go4expert.com/)
-   PHP (http://www.go4expert.com/forums/php/)
-   -   Dynamic HTML/PHP/MySQL Form (http://www.go4expert.com/forums/dynamic-html-php-mysql-form-t5219/)

coool 12Jul2007 09:16

Dynamic HTML/PHP/MySQL Form
 
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..

coool 12Jul2007 09:42

Re: Dynamic HTML/PHP/MySQL Form
 
here's an image of a form I'm planning to code :)

http://img502.imageshack.us/my.php?image=formfb7.jpg

pradeep 12Jul2007 09:43

Re: Dynamic HTML/PHP/MySQL Form
 
Show me the pic, I might get a better idea of what you want!

coool 12Jul2007 09:44

Re: Dynamic HTML/PHP/MySQL Form
 
I just did.. :)

pradeep 12Jul2007 09:48

Re: Dynamic HTML/PHP/MySQL Form
 
The 1st form is easy, you'll find a lot of free JavaScript code to move items between select boxes!

coool 12Jul2007 09:58

Re: Dynamic HTML/PHP/MySQL Form
 
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 :)

pradeep 12Jul2007 10:02

Re: Dynamic HTML/PHP/MySQL Form
 
This one will help you http://www.mattkruse.com/javascript/selectbox/

coool 12Jul2007 21:56

Re: Dynamic HTML/PHP/MySQL Form
 
Thanks alot.. this is really useful :)


All times are GMT +5.5. The time now is 00:55.