summaryrefslogtreecommitdiff
path: root/modules/contact/contact.pages.inc
diff options
context:
space:
mode:
Diffstat (limited to 'modules/contact/contact.pages.inc')
-rw-r--r--modules/contact/contact.pages.inc15
1 files changed, 10 insertions, 5 deletions
diff --git a/modules/contact/contact.pages.inc b/modules/contact/contact.pages.inc
index 041c05153..00ad4cab8 100644
--- a/modules/contact/contact.pages.inc
+++ b/modules/contact/contact.pages.inc
@@ -28,11 +28,16 @@ function contact_mail_page() {
$form = $categories = array();
- $result = db_query('SELECT cid, category, selected FROM {contact} ORDER BY weight, category');
- while ($category = db_fetch_object($result)) {
- $categories[$category->cid] = $category->category;
- if ($category->selected) {
- $default_category = $category->cid;
+ $result = db_select('contact')
+ ->fields('contact', array('cid', 'category', 'selected'))
+ ->orderby('weight')
+ ->orderby('category')
+ ->execute();
+
+ foreach ($result as $record) {
+ $categories[$record->cid] = $record->category;
+ if ($record->selected) {
+ $default_category = $record->cid;
}
}