SELECT og UPDATE i samme ark?

Kode 

<?

$db = mysql_connect("192.168.1.3", "cjstudios", "batman");
mysql_select_db("cjstudios", $db);

switch(@$_GET['mode'])
{
  case 'update':
     mysql_query("UPDATE indhold SET `overskrift` = '".$_POST['nyoverskrift']."', `tekst` = '".$_POST['nytekst']."' WHERE `menu` = 'projects'") or die(mysql_error());
break;
default:

$foresp1 = mysql_query("SELECT * FROM indhold WHERE menu = 'projects'") or die(mysql_error());

	$gammeldata = mysql_fetch_array($foresp1);

	?>

	<form method="post" action="<? echo $_SERVER['PHP_SELF']; ?>?mode=update">
		overskrift:<BR>
		<textarea type="text" name="nyoverskrift">
			<? echo $gammeldata['overskrift']; ?>
		</textarea>
		<br>
		tekst:
		<br>
		<textarea name="nytekst">
			<? echo $gammeldata['tekst']; ?>
		</textarea>
		<input type="submit" name="submit" value="skriv">
	</form>

	<?

	break;
}
?>

Kode 

switch($_GET['mode'])
{
case 'list':
   mysql_query("SELECT * FROM ....");
   break;
case 'update':
   mysql_query("UPDATE ......");
   break;
default:
   print ".....";
   break;
}

Kode 

switch($_GET['mode'])
case 'edit':
  $id = $_GET['id'];
  $query = mysql_query("SELECT * FROM tagwall WHERE id LIKE '$id'");
  
  $row = mysql_fetch_array($query);

  print '<form action="test.php?mode=update" method="post">
<input type="text" value="$row[name]">  
</form>'
  break;
case 'update':
  mysql_query("UPDATE tagwall name = $_POST['name'] WHERE id LIKE $id");
  break;
default:
 break;
}

Kode 

<?
$db = mysql_connect("", "", "");
mysql_select_db("", $db);

$foresp1 = mysql_query("SELECT * FROM indhold WHERE menu='projects'");
echo mysql_error();
while($gammeldata = mysql_fetch_array($foresp1)){

?>

<FORM METHOD=POST ACTION=<? echo $PHP_SELF; ?>>
overskrift:<BR>
<TEXTAREA TYPE=TEXT NAME=nyoverskrift><? echo $gammeldata['overskrift']; ?></TEXTAREA><BR>
tekst:<BR>
<TEXTAREA NAME=nytekst><? echo $gammeldata['tekst']; ?></TEXTAREA><BR>
<INPUT TYPE=SUBMIT VALUE=skriv>
</FORM>

<?
}

mysql_query("UPDATE indhold SET overskrift = '.$_POST['nyoverskrift']' AND tekst = '.$_POST['nytekst']' WHERE menu = 'projects'");

?>

Kode 

<?
$db = mysql_connect("", "", "");
mysql_select_db("", $db);

if($_POST['submit'])
{
mysql_query("UPDATE indhold SET overskrift = '.$_POST['nyoverskrift']' AND tekst = '.$_POST['nytekst']' WHERE menu = 'projects'");
} else {


$foresp1 = mysql_query("SELECT * FROM indhold WHERE menu='projects'") or die(mysql_error());

while($gammeldata = mysql_fetch_array($foresp1))
{

?>

<FORM METHOD=POST ACTION=<? echo $_SERVER['PHP_SELF']; ?>>
overskrift:<BR>
<TEXTAREA TYPE=TEXT NAME=nyoverskrift><? echo $gammeldata['overskrift']; ?></TEXTAREA><BR>
tekst:<BR>
<TEXTAREA NAME=nytekst><? echo $gammeldata['tekst']; ?></TEXTAREA><BR>
<INPUT NAME=SUBMIT TYPE=SUBMIT VALUE=skriv>
</FORM>

<?

}

}
?>

prøv det her

Kode 

<?
$db = mysql_connect("", "", "");
mysql_select_db("", $db);

if($_POST['submit'])
{
mysql_query("UPDATE indhold SET overskrift = '$_POST[nyoverskrift]' AND tekst = '$_POST[nytekst]' WHERE menu = 'projects'");
} else {


$foresp1 = mysql_query("SELECT * FROM indhold WHERE menu='projects'") or die(mysql_error());

while($gammeldata = mysql_fetch_array($foresp1))
{

?>

<FORM METHOD=POST ACTION=<? echo $_SERVER['PHP_SELF']; ?>>
overskrift:<BR>
<TEXTAREA TYPE=TEXT NAME=nyoverskrift><? echo $gammeldata['overskrift']; ?></TEXTAREA><BR>
tekst:<BR>
<TEXTAREA NAME=nytekst><? echo $gammeldata['tekst']; ?></TEXTAREA><BR>
<INPUT NAME=SUBMIT TYPE=SUBMIT VALUE=skriv>
</FORM>

<?

}

}
?>