[Resolved] Why don't work this not

[gvanaco]

<?


// ---------------------------------------------------------------------
include("db_connect.php");
// ---------------------------------------------------------------------

$query = "SELECT Cot_FR_id,Cot_FR_rotsn FROM Cot_FR";
$result = mysql_query($query, $mysql_access);

 while($row = mysql_fetch_row($result)) 
	{
		if ($row[0] <> $row[1]){

		$query1 = "INSERT INTO Cot_FR (Cot_FR_rotsn) VALUES ($row[0]) WHERE Cot_FR_id = '$row[0]'";
		$result1 = mysql_query($query1, $mysql_access);
	}

}

		mysql_close($mysql_access);

		echo "gedaan <br>";
		echo "$query <br>";
		echo "$query1 <br>";
		echo "$result1 <br>";

?>

the result of the echo

gedaan
SELECT Cot_FR_id,Cot_FR_rotsn FROM Cot_FR
INSERT INTO Cot_FR (Cot_FR_rotsn) VALUES (972) WHERE Cot_FR_id = '972'

But my table is not change.
is this normal?

[leatherback]

Hi,

The insert doesn't take an where statement

J.

[gvanaco]

it's true I have to use the update thing, thanks