ABP QAs:
"target") {
$faq_values = Get_Answer($target);
$qname = $faq_values[0];
$question = $faq_values[1];
// $answer = nl2br($faq_values[2]);
$answer = $faq_values[2];
echo "| \n";
echo " | \n";
echo "
";
echo "
$question
\n";
echo "
";
echo "
$answer
\n";
echo "Back \n";
echo " | \n";
} else {
// echo "No Target Selected Yet
\n";
Get_Questions('yes');
}
function Get_Questions($status) {
if (DEBUG == "ON") {
echo "#DEBUG: Querying for All Questions \n";
}
$host = 'web.abptech.com';
$database = 'db_ABPWeb';
$table_id = 'qa';
$query = "SELECT qname, question FROM $table_id where `active` = '" . $status . "' ORDER BY `question`;";
if (DEBUG == "ON") {
echo "#DEBUG: Query = $query \n";
}
if (!$dbconnect = mysql_connect($host, 'root', 'qahelper')) {
echo "Password Check: Connection failed to the host $host.";
exit;
} // if
if (!mysql_select_db($database)) {
echo "Password Check: Cannot connect to database $database.";
exit;
} // if
$dbresult = mysql_query($query, $dbconnect);
/* Performing SQL query */
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$x = 1;
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
?>
|
|
|