UPDATE then INSERT multi rowa

[hipnoz]

Kad notiek UPDATE vins visu updeito, bet nevis tikai tos kur es ierakstu skaitli. Gribetu lai tiek update un insert tikai tie kur value ir kads skaitlis.

 

Kads sim kodam bus skripts kas insert jauna table update datus?

Ka panakt ka update un insert tikai kur value ir kads skaitlis?

 

 

 

<?php

include ("connection/connect_db.php");

 

echo "test_update TABLE data:</br>";

 

////:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

$sql="SELECT * FROM test_update ORDER BY id ASC;";

$result=mysql_query($sql);

// Count table rows

$count=mysql_num_rows($result);

////:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

 

?>

<table width="500" border="0" cellspacing="1" cellpadding="0">

<form name="form1" method="post" action="">

<tr>

<td><strong>Id</strong></td>

<td><strong>Vards</strong></td>

<td><strong>Uzvards</strong></td>

<td><strong>Skaitlis</strong></td>

<td><strong>Atņemt</strong></td>

 

</tr>

<tr>

<?php

while ($row = mysql_fetch_array($result)){ ?>

<tr>

<td><?php echo $row['id']; ?></td>

<td><?php echo $row['vards']; ?></td>

<td><?php echo $row['uzvards']; ?></td>

<td><?php echo $row['skaitlis']; ?></td>

<td><input type="text" name="foo[<?php echo $row['id']; ?>]" value='' /></td>

<tr>

<? } ?>

<tr>

<td colspan="4" align="center">

<input type="submit" name="Submit" value="Submit">

</td>

</tr>

 

</form>

</table>

 

 

<?php

 

if (isset ($_POST['Submit']))

{

 

 

foreach($_POST['foo'] as $key=>$v){

$sql1="UPDATE test_update SET skaitlis=(skaitlis-$v) WHERE id='$key'" or die(mysql_error());

$result1=mysql_query($sql1);

}

echo "update complete";

header ("Location: update_insert.php");

 

}

?>

 

<?php

 

 

 

 

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////