';
echo '
';
echo '';
echo ' | Submit Date | ';
echo ' Problem | ';
echo ' Solution | ';
echo ' Status | ';
echo ' Action Date | ';
echo '
';
$q1 = "select * from support where site = 'CA' order by record_no";
$result = mysql_query($q1);
if (!$result)
{
die(mysql_error());
exit;
}
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "";
echo "| ".$row["submit_date"]." | ";
echo "".$row["problem"]." | ";
echo "".$row["solution"]." | ";
echo "".$row["status"]." | ";
echo "".$row["date_resolved"]." | ";
echo "
";
}
}
//VIEW FEEDBACK
elseif ($view_type == 'F')
{
echo '';
echo '
';
echo '';
echo ' | Submit Date | ';
echo ' QU 1 | ';
echo ' Comments 1 | ';
echo ' QU 2 | ';
echo ' Comments 2 | ';
echo ' QU 3 | ';
echo ' Comments 3 | ';
echo ' QU 4 | ';
echo ' Comments 4 | ';
echo ' QU 5 | ';
echo ' Comments 5 | ';
echo ' QU 6 | ';
echo ' Comments 6 | ';
echo ' Buy | ';
echo ' Explain Purchase | ';
echo ' Suggestions | ';
echo '
';
$q1 = "select * from survey1 where site = 'CA' order by rec_no";
$result = mysql_query($q1);
if (!$result)
{
die(mysql_error());
exit;
}
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "";
echo "| ".$row["submit_date"]." | ";
echo "".$row["ques1"]." | ";
echo "".$row["comment1"]." | ";
echo "".$row["ques2"]." | ";
echo "".$row["comment2"]." | ";
echo "".$row["ques3"]." | ";
echo "".$row["comment3"]." | ";
echo "".$row["ques4"]." | ";
echo "".$row["comment4"]." | ";
echo "".$row["ques5"]." | ";
echo "".$row["comment5"]." | ";
echo "".$row["ques6"]." | ";
echo "".$row["comment6"]." | ";
echo "".$row["buy1"]." | ";
echo "".$row["purch_explain"]." | ";
echo "".$row["suggestions"]." | ";
echo "
";
}
}
}
?>
Home :
About :
Services :
Products :
Contacts :
News & Release
Copyright © 2001 - 2005 TrakSoft. All Rights Reserved.
Admin View Page