 |
|
AGTL Discussion Board
$db = mysql_connect("localhost", "root", "m082440m");
mysql_select_db("fln",$db);
$sql = "
SELECT
agtlactivitydesc.module,
agtlmodules.name as modulename,
agtlmodules.directory as activitydirectory,
agtlactivitydesc.activity as activitynumber,
agtlactivitydesc.title,
agtlactivitydesc.location as activitylocation,
agtlactivities.answer,
agtlactivities.ID as activityanswerID
FROM agtlactivitydesc
LEFT JOIN agtlactivities on agtlactivitydesc.module = agtlactivities.module
AND agtlactivitydesc.activity = agtlactivities.question
AND agtlactivities.agtluserID = '$ID'
LEFT JOIN agtlmodules on agtlactivitydesc.module = agtlmodules.module
WHERE agtlactivitydesc.module = '4'
ORDER BY agtlactivitydesc.activity
";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
if ($myrow) {
$modulename = $myrow["modulename"];
echo "
| AGTL Discussion Board |
";
do {
$activitymodule = $myrow["module"];
$activitynumber = $myrow["activitynumber"];
$activitytitle = $myrow["title"];
$answer = nl2br($myrow["answer"]);
$activitynumber = $myrow["activitynumber"];
$activitylocation = $myrow["activitylocation"];
$activitydirectory = $myrow["activitydirectory"];
echo "
|
|
";
} while ($myrow = mysql_fetch_array($result));
}
echo"
|
";
?>
include("../../../mfooter.inc"); ?>
|