blob: 0b4b1e2a1fec7b15911d6425c4efd96cbd9b9077 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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);
}
?>
|
