function retrieve_relationships($table, $values, $select_id)
{
$query = "SELECT {$select_id} FROM {$table} WHERE deleted = 0 ";
foreach ($values as $name => $value) {
$query .= " AND {$name} = '{$value}' ";
}
$query .= " ORDER BY {$select_id} ";
$result = $this->db->query($query, false, "Retrieving Relationship:" . $query);
$ids = array();
while ($row = $this->db->fetchByAssoc($result)) {
$ids[] = $row;
}
return $ids;
}
/**
* can also issue a unique randomly generated token/code instead of a sequential code...
*
* @param array $rcnum Databases Row
* @param DBHelper $db
*/
private static function ittap_issue_token($rcnum, $db)
{
if ($rcnum['check_unique'] == 0) {
return self::ittap_make_token($rcnum['value_min_length']);
}
$code_unique = false;
while (!$code_unique) {
$token = self::ittap_make_token($rcnum['value_min_length']);
$sql = "SELECT `{$rcnum['field_name']}` FROM `{$rcnum['module_id_name']}` WHERE `{$rcnum['field_name']}` = '{$token}';";
$result = $db->query($sql);
$row = $db->fetchByAssoc($result);
if (empty($row[$rcnum['field_name']])) {
$code_unique = true;
}
}
return $token;
}
