diff options
Diffstat (limited to 'admin/rudi/includes/functions.awards.php')
| -rw-r--r-- | admin/rudi/includes/functions.awards.php | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/admin/rudi/includes/functions.awards.php b/admin/rudi/includes/functions.awards.php new file mode 100644 index 0000000..439f0e1 --- /dev/null +++ b/admin/rudi/includes/functions.awards.php @@ -0,0 +1,20 @@ +<?php
+
+ function getAwardClasses(){
+ global $db;
+ $result = $db->Query("SELECT `name`, `class_id` FROM `rudi_award_classes`");
+ return $db->Fetch($result);
+ }
+
+ function getAwardsByClass($class_id){
+ global $db;
+ $result = $db->Query("SELECT `award_id`, `name`, `image`, `description` FROM `rudi_awards` WHERE `class_id` = '$class_id' ORDER BY `name`");
+ return $db->Fetch($result);
+ }
+
+ function getAward($award_id){
+ global $db;
+ $result = $db->Query("SELECT `award_id`, `name`, `image`, `description`, `class_id` FROM `rudi_awards` WHERE `award_id` = '$award_id' LIMIT 1");
+ return $db->FetchRow($result);
+ }
+?>
\ No newline at end of file |