• From: Ukraine
  • Registered: 2008-10-31
  • Posts: 762

Topic: Order and Limit in Delete Query

Now in MySQL/MySQLi supported only WHERE paramaters for DELETE query.
Will be good and usefull add support for ORDER BY and LIMIT

else if (isset($query['DELETE']))
{
    $sql = 'DELETE FROM '.(isset($query['PARAMS']['NO_PREFIX']) ? '' : $this->prefix).$query['DELETE'];

    if (!empty($query['WHERE']))
        $sql .= ' WHERE '.$query['WHERE'];
}