phpMyFAQ

Code: Select all

function printOpenQuestions()
{
	global $db, $sids, $sqltblpre, $msg2answer, $msgNoQuestionsAvailable;
	$categories = getCategories();
	
	$query = "SELECT id,ask_username,ask_usermail,ask_rubrik,ask_content,ask_date FROM ".$sqltblpre."faqfragen ORDER BY ask_date ASC";
	$result = $db->query($query);
	$output = "";
	if ($db->num_rows($result) > 0) {
		while ($row = $db->fetch_object($result)) {
			$output .= "\t<tr class=\"openquestions\">\n";
			$output .= "\t\t<td valign=\"top\" nowrap>".makeDate($row->ask_date)."<br><a href=\"mailto:".$row->ask_usermail."\">".$row->ask_username."</a></td>\n";
			$output .= "\t\t<td valign=\"top\"><b>".$categories[$row->ask_rubrik].":</b><br>".stripslashes($row->ask_content)."</td>\n";
        	$output .= "\t\t<td valign=\"top\"><a href=\"".$_SERVER["PHP_SELF"]."?".$sids."aktion=add&question=".rawurlencode($row->ask_content)."&rubrik=".$row->ask_rubrik."\">".$msg2answer."</a></td>\n";
    		$output .= "\t</tr>\n";
			}
		}
	else {
		$output = "\t<tr>\n\t\t<td colspan=\"3\">".$msgNoQuestionsAvailable."</td>\n\t</tr>\n";
		}
	return $output;
}