Megan — Wed, 19 Sep 2007 18:18:00 +0000

Ooooh, thanks a lot! I was trying to figure out how I could pass two values through the form input.

I could have gone through phpMyAdmin to update this but I didn't want to make someone else do that (I might be leaving my job soon and I don't want to expect the next person to do that).

pr0gr4mm3r — Wed, 19 Sep 2007 17:20:29 +0000

Here is some (untested) code that will show a form to update the entire table at once.

Code to show the form:

<?php
    /* insert connecting code here */
    
    $result = mysql_query(\"SELECT * FROM table_name\");
    
    echo '<form method=\"post\" action=\"somepage.php\">';
    for ($i = 0; $i < mysql_num_rows($result); $i++)
    {
        $row = mysql_fetch_assoc($result);
        
        /* now output the form fields */
        echo '<input type=\"text\" size=\"30\" name=\"data[' . $row['ID'] . '][roomtype]\" value=\"' . $row['roomtype'] . '\" /><br />';
        echo '<input type=\"text\" size=\"30\" name=\"data[' . $row['ID'] . '][rezname]\" value=\"' . $row['rezname'] . '\" /><br />';
        echo '<input type=\"text\" size=\"30\" name=\"data[' . $row['ID'] . '][fall]\" value=\"' . $row['fall'] . '\" /><br />';
        echo '<input type=\"text\" size=\"30\" name=\"data[' . $row['ID'] . '][winder]\" value=\"' . $row['winder'] . '\" /><br />';
        echo '<input type=\"text\" size=\"30\" name=\"data[' . $row['ID'] . '][spring]\" value=\"' . $row['spring'] . '\" /><br />';
        echo '<br /><br />';
    }
    echo '<input type=\"submit\" value=\"Submit\" />';
    echo '</form>';
?>

Code to process the form:

<?php
    foreach ($_POST['data'] as $field => $value)
    {
        $roomtype = $value['roomtype'];
        $rezname = $value['rezname'];
        $fall = $value['fall'];
        $winter = $value['winter'];
        $spring = $value['spring'];
        $id = $field;
        
        $query = \"UPDATE table_name SET roomtype = '$roomtype', rezname = '$rezname', fall = '$fall', winter = '$winter', spring = '$spring' WHERE ID = $id\";
        
        /* run that query */
    }
?>

Basically use form field arrays to submit multiple rows of data for updating.

Also, if you want a quick and dirty way of doing it, phpMyAdmin can update multiple rows at once.

Megan — Wed, 19 Sep 2007 13:21:52 +0000

Is this what you were looking for?

Field 		Type 		Null 	Key 	Default      Extra 
ID		tinyint(2)	NO	PRI	 	 
roomtype	varchar(100)	NO	 	 	 
rezname		varchar(10)	NO	 	 	 
fall		decimal(20,0)	NO	 	 	 
winter		decimal(20,0)	NO	 	 	 
spring		decimal(20,0)	NO	 	 	 	 

pr0gr4mm3r — Tue, 18 Sep 2007 21:43:03 +0000

Could you post the structure of the table?

The result of this query would help: SHOW COLUMNS FROM table_name