Code: Select all
<?php
$db = mysql_connect($db_host, $db_user, $db_pass);
mysql_select_db($db_name,$db) or die("<P>Query failed: ".mysql_error());
$result = mysql_query("SELECT CONCAT(t3.lastname, t3.firstname, t2.stored_questionnaire_ID, t1.questionnaire_name, t2.stored_questionnaire_date) AS Link FROM qst_questionnaires AS t1, qst_stored_questionnaires AS t2, mos_comprofiler AS t3 WHERE t1.questionnaire_ID = t2.questionnaire_ID AND t3.user_id = t2.user_ID",$db);
echo "<center>You are viewing the completion information for the assessments<br /><br />";
echo "<TABLE BORDER=\"2\" cellpadding=\"5\">";
echo "<TR><TD><B>First Name</B><TD><B>Last Name</B><TD><B>Questionnaire</b><TD><B>Completed On</B></TR>";
while ($myrow = mysql_fetch_array($result))
{
echo "<TR><TD>".$myrow["t3.firstname"]."<TD>".$myrow["t3.lastname"]."<TD>".$myrow["t1.questionnaire_name"]."<TD align=\"center\">".$myrow["t2.stored_questionnaire_date"];;
}
echo "</TABLE></center>";
?>Any ideas where I've gone wrong?
Thanks,
Scott