Greetings,

Can someone please tell me why the following query is failing?

        $qryupdate = "INSERT INTO Warranty (servicetag, description, provider, startdate, enddate, daysleft) " .
                "VALUES ('$servicetag', '$description', '$provider', '$startdate', '$enddate', '$daysleft') " .
                "WHERE (servicetag='$servicetag', description='$description', provider='$provider', " .
                "startdate='$startdate', enddate='$enddate')";

        $results = mysql_query($qryupdate);

Thanks,

*Nick*

A regular INSERT query like this will fail if you add the WHERE clause. You will want to set the variables $servicetag, $description, etc before you build the query string. Also, I don't know what the type is for the field $daysleft, but if it is an INT then you do not want to put the single quotes around $daysleft.