You have several opportunities here :
1.If you use mysql 4.1.x you can use
"insert into .. on duplicate key update" (check the correct syntax)
2.You can make unique key from the two columns and check for error number 1062
(duplicate key) like this :
myusql_query($qins) or $errno=mysql_errno();
William Stokes a écrit :
Hello,
I'm updating a table with following SQL statement
$sql = "INSERT INTO x_ikaluokat (ryhma, ikaluokka)
VALUES ('$ryhma','$ikaluokka')";
What would be the best way to test that similar rows doesn't get created to
the table? I can't make both columns unique.
William Stokes wrote:
Hello,
I'm updating a table with following SQL statement
$sql = "INSERT INTO x_ikaluokat (ryhma, ikaluokka)
VALUES ('$ryhma','$ikaluokka')";
What would be the best way to test that similar rows doesn't get created to
the table? I can't make both columns unique.
You
Hello,
I'm updating a table with following SQL statement
$sql = "INSERT INTO x_ikaluokat (ryhma, ikaluokka)
VALUES ('$ryhma','$ikaluokka')";
What would be the best way to test that similar rows doesn't get created to
the table? I can't make both columns unique.
Thanks
-Will
--
PHP Gener
4 matches
Mail list logo