diff -u b/dbtng_example/dbtng_example.module b/dbtng_example/dbtng_example.module --- b/dbtng_example/dbtng_example.module +++ b/dbtng_example/dbtng_example.module @@ -606,12 +606,13 @@ * @return array */ function dbtng_example_execute_ordered_select_query() { - $dbtng_example_execute_ordered_select_query = db_select('dbtng_example', 'dbtng_example')->fields('dbtng_example'); - // 'dbtng_example.name' is the field on which to order where 'dbtng_example' - // is a table alias and 'name' is a column name + $tableName = 'dbtng_example'; + $tableAlias = 'ex'; + $columnName = $tableAlias . '.name'; + $dbtng_example_execute_ordered_select_query = db_select($tableName, $tableAlias)->fields($tableAlias); // Legal values for sorting are "ASC" and "DESC". Any other value will be // converted to "ASC". - $dbtng_example_execute_ordered_select_query->orderBy('dbtng_example.name', 'ASC'); + $dbtng_example_execute_ordered_select_query->orderBy($columnName, 'ASC'); $dbtng_example_result = $dbtng_example_execute_ordered_select_query->execute()->fetchAll(); return $dbtng_example_result; @@ -626,7 +627,7 @@ * * @return array */ -function dbtng_example_converts_resultset_to_table_rows($result) { +function dbtng_example_convert_resultset_to_table_rows($result) { $rows = array(); if($result) { foreach ($result as $row) { @@ -638,7 +639,7 @@ } /** - * This function renders array for table 'dbtng_example' + * This function converts a resultset into a render array * @param array $result * Resultset of the query * @@ -647,7 +648,7 @@ * @return array */ function dbtng_example_convert_resultset_to_table_render_array($result) { - $rows = dbtng_example_converts_resultset_to_table_rows($result); + $rows = dbtng_example_convert_resultset_to_table_rows($result); $header = array(t('Id'), t('uid'), t('Name'), t('Surname'), t('Age')); return [ '#theme' => 'table',