Hey guys,
I have a problem. I want to write a record in my db when it does not already exists. For this, i have been looking on the web and found multiple solutions on Stackoverflow. The one I use is proved working, by the stack user however I get my die response :(.
I use the following query (mysql/php):
$query= "IF NOT EXISTS (SELECT * FROM tasksmade WHERE teamnumber='$teamnumber' AND tasknumber='$tasknumber' AND date='$date')
INSERT INTO tasksmade (teamnumber, tasknumber, taskfinished, date)
VALUES ('$teamnumber', '$tasknumber', '$taskfinished', '$date')";
$result= mysql_query($query,$mysql) or die("The query result has failed on the db!");
Hope someone can help!
Thanks!