MYSQL Update statment not working

[Comdemned]

Hi All,

 

I have a pretty basic mysql update statment that for some reason is not working properley.

<?php
$query = "INSERT INTO apptype (name, description, timeframe, last_modified) VALUES ('$name', '$description', '$timeframe', '$client_id')";
mysql_query($query, $db);
mysql_close($db);
?>

 

Any help would be greatly appricated.

 

Many thanks

Murray

 

[revraz]

mysql_query($query, $db) or die (mysql_error());

 

[Comdemned]

Sorry I pasted the wrong code.

 

Here is the code that I am having a problem with.

 

<?php
$query = "UPDATE apptype SET name='$name', description='$description' timeframe='$timeframe', last_modified='$client_id' WHERE type_id='$id'";
mysql_query($query, $db);
?>

 

Thanks again

 

[revraz]

Missing a comma here

 

description='$description'

 

And you should still check for query errors like my post above.  It would have told you the error.