Documentation

Database Access

Database Deletes

Database deletes are best done manually, using an skey value, but Andromeda does provide the SQLX_Delete function as well.

<?php
class x6example extends androX6 {
    function x6main() {
        $row = array(
            skey=>1234
        );
        SQLX_Delete('articles',$row);
    }    
}

The SQLX_Delete function creates a command that includes all of the fields provided in the $row parameter.

Providing an skey value in the $row is the only way to be certain that exactly one row will be deleted.

If your $row array contains values that would result in deleting half of the rows in a table -- then that is what will happen!