Could someone please tell me how to delete rows from a table by using the ADOdb library. I have been looking everywhere for an example, including the manual, but can’t find anything.
This is what I have tried to do:
$query = 'delete from table where =\''.$id.'\'';
$conn = &ADONewConnectionDATABASETYPE);
$conn->PConnect(DATABASENAME, USERNAME, PASSWORD);
$rs = $conn->Execute($query);
$conn->Close();
However, it seems that when I update the row with an empty primary key, the row or record gets deleted, but it is too dodgy.
Advice would be great!
