[Resolved] Update and delete

[Ikonsmx]

Hello

is it possible to Update and Delete a record at the same time?

For example if the value is = 0 delete the record, otherwise update it.

I know that is simple but I'm having some trouble with the code

$sql ="UPDATE myDb SET
AvailableSF='$AvailableSF',
WHERE ID='$ID'";
$ok = mysql_query($sql);

$sSQL="Delete From myDb Where AvailableSF=0 ";

or

is this correct?
if ($availablespaceSF = 0)
$sSQL="Delete From availablespace ";

Thanx for your help

[hmemnon]

if ($AvailableSF==0){
 $qry="DELETE FROM table WHERE id='$ID'";
}
else{
 $qry="UPDATE table SET AvailableSF='$AvailableSF' WHERE ID='$ID'"; 
}

This way you'll never have to check if the value in the field is 0, because whenever you receive an update order to make it 0, you delete the row automaticly...

Cheers