UPDATING DATABASE

Language: PHP
// checks to see if update button pressed
if ($_SERVER[';REQUEST_METHOD';] == ';POST';)
{
//assigns values in textareas to variables
$type_id = $_GET[';type_id';];
$name = $_POST[';name';];
$origin = $_POST[';origin';];
$strength = $_POST[';strength';];
$price = $_POST[';price';];
 
//updates the database with name, origin, strength and price based on id variable
$update = "UPDATE info SET name = $name, origin = $origin, strength = $strength, price = $price WHERE type_id = $type_id";
$result = mysql_query($update);
print "<br>The coffee $name from $origin was succesfully updated.<br>Price: $price and Strength: $strength .";  
}

Language: PHP
$update = "UPDATE info SET name = ';$name';, origin = ';$origin'; //etc.

Language: PHP
//GET THE MODULE ID VALUE
    $module_id = $_GET[';module_id';];
 
    //get data from database
    $result = mysql_query("SELECT * FROM module WHERE module_id = ';$module_id';")
    or die (mysql_error());
 
   $row = mysql_fetch_array($result);