Update на таблица

[sle]

dи :?

 

[tedo96]

Правиш си едно скрито поле и то ще ти взима id-то:
<input type="hidden" name="id" value="'.$row['id'].'"/>

 

[sle]

gw

 

[IvanAdamov]

if(isset($_POST['but'])) {

$a=$_POST['a'];

$b=$_POST['b'];

$id=$_GET['id'];

 

[tedo96]

<?php
if(isset($admin)) {  
	$query=mysql_query("SELECT * FROM sle");
	while($rows = mysql_fetch_array($query)){
		echo  '
		<form method="post">
		<input type="hidden" name="idto" value="'.$rows['id'].'" />
		<input type="text" name="a" value="'.$rows['edno'].'" />
		<input type="text" name="b" value="'.$rows['dve'].'" />';
	}
	echo '<input type="submit" name="but" value="Обнови" /></form>';

	if(isset($_POST['but'])) {
		$a=$_POST['a'];
		$b=$_POST['b'];
		$id=$_POST['idto'];

		$update=mysql_query("UPDATE sle SET `edno`='".$a."', `dve`='".$b."' WHERE id='$id' ") or die(mysql_error);
	}
} else  {
	echo 'bez prava';
}
?>

 

[sle]

<?php
if(isset($admin)) {  
	$query=mysql_query("SELECT * FROM sle");
	while($rows = mysql_fetch_array($query)){
		echo  '
		<form method="post">
		<input type="hidden" name="idto" value="'.$rows['id'].'" />
		<input type="text" name="a" value="'.$rows['edno'].'" />
		<input type="text" name="b" value="'.$rows['dve'].'" />';
	}
	echo '<input type="submit" name="but" value="Обнови" /></form>';

	if(isset($_POST['but'])) {
		$a=$_POST['a'];
		$b=$_POST['b'];
		$id=$_POST['idto'];

		$update=mysql_query("UPDATE sle SET `edno`='".$a."', `dve`='".$b."' WHERE id='$id' ") or die(mysql_error);
	}
} else  {
	echo 'bez prava';
}
?>

Същото като моя варянт е .. работи само като редактирам последното поле от цикъла

 

[IvanAdamov]

WHERE `id` ="'.$_POST['id'].'"';

 

[sle]

fe

 

[akatsuki]

Само си смени полетата. Ако не можеш, ще го пробвам аз:

 <?php
  $post_id = (inT)$_GET['post'];
  
  if(!isset($post_id) || !is_numeric($post_id) || $post_id < 1)
  {
      header('Location: index.php');
	 exit();
  }
  $result= mysql_query("SELECT post_id, title, content FROM posts WHERE post_id='$post_id'");
  $post = mysql_fetch_assoc($result);
  if(isset($_POST['editPost']))
  {
     $title = $_POST['title'];
     $content = $_POST['content'];
	 $q = "UPDATE posts SET title='$title', content='$content' WHERE post_id='$post_id'";
     mysql_query($q) or die(mysql_error());
  }
?>
<?php if(isset($_POST['editPost'])): ?>
<p>Успешно редактира новината.</p>
<?php endif; ?>
<?php if(!isset($_POST['editPost'])) : ?>
 <p>
  <form action="" method="post">
   Заглавие: <input type="text" name="title"  value="<?php echo $post[title]; ?>"/><br />
   Новина:<br />
   <textarea name="content" cols="30" rows="5" ><?php echo $post[content]; ?></textarea><br />
   <input type="submit" name="editPost" value="Редактирай">  
  </form>
 </p>
<?php endif;  ?>

 

[akatsuki]

<?php
if(isset($admin)) {  
        $query=mysql_query("SELECT * FROM sle");
		$Arr = array(array()); $i = 1;
        while($rows = mysql_fetch_array($query))
		{
                $Arr[$i][1] = $rows['id'];
				$Arr[$i][2] = $rows['edno'];
				$Arr[$i][3] = $rows['dve'];
				echo  '
                <form method="post">
                <input type="hidden" name="idto" value="'.$rows['id'].'" />
                <input type="text" name="a" value="'.$rows['edno'].'" />
                <input type="text" name="b" value="'.$rows['dve'].'" />';
        $i = $i +1;
		}
        echo '<input type="submit" name="but" value="Обнови" /></form>';

        if(isset($_POST['but'])) 
		{
		    $n = 1;
			while($n <= $i) 
			{
                $a=$Arr[$n][2];
                $b=$Arr[$n][3];
                $id=$Arr[$n][1];

                $update=mysql_query("UPDATE sle SET `edno`='".$a."', `dve`='".$b."' WHERE id='$id' ") or die(mysql_error);
			    $n = $n +1;
			}	
        }
} else  {
        echo 'bez prava';
}
?