[Resolved] Simple problem with database update

[sunshine66]

Hi,
I have a simple update query that does not update the MySQL database... I have no clue why not. I've used a similar version of this code before and it works. HELP!

	$sqlK = "UPDATE employeeProfile SET
			ExpireDate 	='$Expire2Year-$Expire2Month-$Expire2Day',
			EventType		='$event',
			DocLetter 	='B/K',
			CoverageTerm	='29',
			COBRA		='Yes' 
      WHERE EmployeeID='$eeID'" or die("Query K error: " . mysql_error() );
	 $resultK = mysql_query($sqlK);  

echo "This is your query <br>" . $sqlK ;

This is your query
UPDATE employeeProfile SET ExpireDate ='2006-10-30', EventType ='Reduced Employee Hours/Disability', DocLetter ='B/K', CoverageTerm ='29', COBRA ='Yes' WHERE EmployeeID='4'

[tomhath]

Move the "or die..." to the line where you run the query instead of where you set $sqlK. It will tell you what's wrong (probably you aren't connected to the database, but that's just a guess).

$resultK = mysql_query($sqlK) or die(...); 

[sunshine66]

Duh! I feel stupid.
Your guess was right.
Thanks Tom!