UPDATE FORM generated by while

dea

Hey there!

the code generates ~ inputs type=text with data in them. - see image
Now i would like to be able to change the data of the inputs to somethingelse and when i push the "ändra" button it will UPDATE the data in my db..
How do i do that?

<?php 
	include("includes/mysql.php");
	include("includes/functions.php");
	open_db_name($db_anv, $db_pwd, $db_name);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link REL="stylesheet" HREF="css/main.css" TYPE="text/css"/>
<link REL="stylesheet" HREF="css/themes.css" TYPE="text/css"/>

</head>
<body>

<?php include("header.php"); 

?>

<tr><td>
	<table border="0" width="100%" cellpadding="0" cellspacing="0" >
		<tr height="29">
			<td background="images/light_blue_back.gif">
				&nbsp <span class="greet_user"> &nbsp </span>
			</td>
		</tr>
	</table>
</td></tr>
</table>

<table border="0" width="99%" cellpadding="10" cellspacing="0" class="nav_box">
	<tr>
		<td>
			<span class="top_tab_font"> Inställningar </span><br>
			<span class="date_font"><?php echo(get_date()); ?></span>
		</td>
	</tr>

<tr>
	<td width="450" valign="top">
			<form action="setup.php" method="post" name="frm_setup" target"_self">
			<br />
			<span class="dark_anchor">Välj Bransch: &nbsp </span>
			<?PHP
			   // Query for default Page Comment
			   $query = "SELECT pid FROM tbl_avdelning";
			   $result = mysql_query ($query);
			   $answer = mysql_fetch_array($result);
			   $Default = $answer[0];
			   // Query for remaining Selections
			   echo('<select name="bransch">');
			   if($result) {					  

			   while ($Row = mysql_fetch_array($result))
			   {
			   		echo('<option value="' . $Default . '" selected="selected">' . $Default . '</option>');
				}
			   echo('</select>');
			   }
			?>
		<br /> <br />
			<span class="dark_anchor">Lägg till ny typ: <input name="text" type="text" size="20"></span>
			<span class="light_brackets">[<span class="light_anchor"> <input type="submit" value="ny"> </span>] &nbsp &nbsp &nbsp &nbsp </span>
		</form>
		<?php
			$text=$_POST['text'];
			if($text != "")
			{
				$query_ins ="INSERT INTO tbl_avdelning (text) VALUES ('$text')";
				$results = mysql_query($query_ins);
					if($results)
					{
						   echo("Du har lagt till en ny Avdelning!");
					}
					else
					{
						 echo("Det gick inte att lägga till någon ny Avdelning!");
					}
			}
		?>
		<br />
		<br />
		<table class="box_caption_<?php echo($theme); ?>" cellpadding="2" cellspacing="0" width="450">
			<tr height="16">
				<td colspan="2">
					<table>
						<tr>
							<td width="200" class="box_caption_font">Avdelningar</td>
						</tr>
					</table>					</td>
			</tr>
			<tr height="16">
				<td colspan="2">
					<table>
						<tr>
							<td width="250">Inmatade</td>
							<td width="90" align="right">&nbsp &Auml;ndra namn </td>
							<td width="60" align="right">Ta bort</td>
						</tr>
					</table>					</td>
			</tr>
			<form action="setup.php" method="post" name="frm_setup" target="_self">
			<?php
				if (isset($_GET["action"]) AND $_GET["action"] == "delete")
				   {
				   $query = mysql_query("DELETE FROM tbl_avdelning WHERE id = '$_GET[id]'")
				   or die(mysql_error());
				   }
				$id = $_REQUEST['id'];							
				$query  = "SELECT id, text FROM tbl_avdelning ORDER BY id ASC";					
				$result = mysql_query($query);			
				if($result) {
				while($line=mysql_fetch_array($result, MYSQL_ASSOC)) {
			   ?>
				<tr class="box_border_<?php echo($theme); ?>">
				<td colspan="2">
					<table>
						<tr class="box_border_<?php echo($theme); ?>">
							<td width="250"><b><?php echo($line['text']); ?></b></td>
							<td width="90" align="right">
							<input name="txt_edit" type="text" value="<?php echo($line['text']); ?>" size="15"/></td>
						  	<td width="60" align="right"><a href="setup.php?id=<?php echo $line['id']; ?>&amp;action=delete" class="dark_anchor"> Ta Bort </a></td>
						</tr>
					</table>					
				</td>
			</tr>
			<?php } 	
			} 
			else {
					echo("Det finns inga avdelningar att hämta!");
				}
			?>
			<tr class="box_border_<?php echo($theme); ?>">
			  <td width="249">&nbsp;</td>
			  <td width="191">
			  <?php
				echo ("<input type=\"submit\" name=\"submit\" value=\"ändra\"></form>");
				?>
			  </td>
			</tr>
		</table>

	</td>
</tr>
</table>
<?php close_db(); ?>
</body>
</html>

iamtheironman


// Well here's the way I do this kind of thing, hope it helps.

// First the input values to be displayed can come from 
// a database row array or the $_POST array

if($_POST['mySubmitButtonName']) 
{    $srcArray=$_POST;
}
else
{    $srcArray=mysql_fetch_array($resultSet);
}


// Then I dont fill form values directly from POST like this  

?><input value="<?= $_POST['text1']; ?>" name="text1"><?

// instead I call a function and pass it the name of the input 
// and the array containing the value

?>
<input value="<?=formVal('text1',$srcArray)?>" name="text1">
<input value="<?=formVal('text2',$srcArray)?>" name="text2">
<?

function formVal($fieldName,$src){

  $val = $src['$fieldName'];
  $val = htmlentities($val);   // apply any required formatting here
  return $val;
}


// That's the displaying part. For updating the database you can 
// put code somewhere at the top of the script 

if($_POST['mySubmitButtonName']) 
{
    if($_POST['text1']=="" || $_POST['text2']=="") // validate and update
    {    $emptyFieldError=true;
    }
    else
    {    $sql="update t1 set f1='".dbFormat($_POST['text1'])."', f2='".dbFormat($_POST['text2'])."' where id=someid"; 
          mysql_query($sql);
    }
}

function dbFormat($val){
	return addslashes($val);  // apply any required formatting here
}