Hi
How can generate form elements(drop-down menu, check boxes and radiobutons etc.) from database content and enter the result of choises in other database table?
Thank you

To, generate form elements(drop-down menu, check boxes and radiobutons etc.) from database you use SELECT STATEMENT and to enter the result of choises in other database table? you use INSERT STATEMENT AND JOIN. if you know MySQL pretty well that will do the job.

Thanks for reply
I'm new in MySQL but I'll read about SELECT and INSERT statements

Remember to learn about JOIN

I am trying to do the same thing. I'd really appreciate some help with making the SQL statement. I'm just not sure what it shoud look like. SELCT what from where, Insert and join it with what??

SELECT statement:

PHP Code:

$result = mysql_query("SELECT * FROM table_name WHERE condition='$condition'"); 


That statement will pull all the data from the database table with the conditions specified.

PHP Code:

$result_array = mysql_fetch_array($result); 


This will put the row in an array and you can access each field individually
(e.g. $name = $result_array['name']


To INSERT the data back into the table use this code:

PHP Code:

$query = "INSERT INTO table_name( field1, field2, field3)
        values( '$field1, '$field2, '$field3')";
                    
    mysql_query($query, $link)
    or die("Couldn't add data to \"table_name\" table: "
    .mysql_error() );

    mysql_close ($link); 


I dont know about the JOIN statement but im sure someone here will...


Hope this helps
Stoot