FAQ

[insert_php]

$host=”db1152.perfora.net”; // Host name
$username=”dbo220623107″; // Mysql username
$password=”wBr7cFFV”; // Mysql password
$db_name=”db220623107″; // Database name

mysql_connect(“$host”, “$username”, “$password”)or die(“cannot connect to server”);
mysql_select_db(“$db_name”)or die(“cannot select database”);

if(is_null($_GET[“q”])) {

echo “

Frequently Asked Questions

“;

echo “

    “;

    $result_faq=mysql_query(“SELECT * FROM faq ORDER BY id_num”);

    $q_num = “1”;
    // grab all the content
    while($r=mysql_fetch_array($result_faq))
    {
    // the format is $variable = $r[“nameofmysqlcolumn”];
    $id_num=$r[“id_num”];
    $question=$r[“question”];
    echo “

  • $question
  • “;
    $q_num++;
    }

    echo “

“;

}
else {

// GET
$id_num = $_GET[“q”];

echo “

Frequently Asked Questions

“;

$result_faq=mysql_query(“SELECT * FROM faq WHERE id_num = $id_num “);

// grab all the content
while($r=mysql_fetch_array($result_faq))
{
// the format is $variable = $r[“nameofmysqlcolumn”];
$question=$r[“question”];
$answer=$r[“answer”];
}

echo “

Question:
” . $question . “

“;
echo “

Answer:
” . $answer . “

“;

echo “

‹ back to frequently asked questions

“;

}

[/insert_php]