Update and Delete not working

[Anon]

Hello,

I'm working with an Access Database and I have to Update and Delete Entries in that database. I wrote a php script like this:
<?PHP
....
if($delete_or_update=="update")
$SQL_query = "UPDATE vakantie SET Goedgekeurd = true WHERE VakantieID like '$vakid'";

else
$SQL_query = "DELETE FROM vakantie WHERE VakantieID=$vakid";

$cor = odbc_exec($cnx, $SQL_query);
....
?>

this script is not returning any errors but it isn't doing anything either.

Is this the way to do this and am I forgetting something or should I do it in a different way?

Rene

[Anon]

if($delete_or_update=="update") }
$SQL_query = "UPDATE vakantie SET Goedgekeurd = true WHERE VakantieID like '$vakid'";
}
else {
$SQL_query = "DELETE FROM vakantie WHERE VakantieID=$vakid";
}

1. the curly brackets were not present.

[Anon]

if($delete_or_update=="update")

$SQL_query = "UPDATE vakantie SET [Goedgekeurd] = 1 WHERE [VakantieID] like '$vakid'";

else
$SQL_query = "DELETE FROM vakantie WHERE VakantieID like '$vakid'";

is working, it weren't the brackets (if you ment these { } ), if you only have 1 line of code after if or any other function that uses these brackets you can leave them out.

thanks for the help anyhow.