summaryrefslogtreecommitdiff
path: root/idiorm.php
diff options
context:
space:
mode:
authorJamie Matthews <[email protected]>2010-10-25 12:29:49 +0100
committerJamie Matthews <[email protected]>2010-10-25 12:29:49 +0100
commit86486f357709b6aa009d4ab8f5442a881a558995 (patch)
tree86c081a5b57b263426416c395688e9cdc4135958 /idiorm.php
parent9e813ef6b5f2fdc12b922e8cd0f7ff7acb46dabf (diff)
Simplify ORDER BY building
Diffstat (limited to 'idiorm.php')
-rw-r--r--idiorm.php16
1 files changed, 3 insertions, 13 deletions
diff --git a/idiorm.php b/idiorm.php
index 0402652..2749ca5 100644
--- a/idiorm.php
+++ b/idiorm.php
@@ -53,10 +53,6 @@
const UPDATE = 0;
const INSERT = 1;
- // Order by array keys
- const ORDER_BY_COLUMN_NAME = 0;
- const ORDER_BY_ORDERING = 1;
-
// Where condition array keys
const WHERE_FRAGMENT = 0;
const WHERE_VALUES = 1;
@@ -515,10 +511,8 @@
* Add an ORDER BY clause to the query
*/
protected function _add_order_by($column_name, $ordering) {
- $this->_order_by[] = array(
- self::ORDER_BY_COLUMN_NAME => $column_name,
- self::ORDER_BY_ORDERING => $ordering,
- );
+ $column_name = $this->_quote_identifier($column_name);
+ $this->_order_by[] = "{$column_name} {$ordering}";
return $this;
}
@@ -596,11 +590,7 @@
if (count($this->_order_by) === 0) {
return '';
}
- $order_by = array();
- foreach ($this->_order_by as $order) {
- $order_by[] = $this->_quote_identifier($order[self::ORDER_BY_COLUMN_NAME]) . " " . $order[self::ORDER_BY_ORDERING];
- }
- return "ORDER BY " . join(", ", $order_by);
+ return "ORDER BY " . join(", ", $this->_order_by);
}
/**