ID | Title | Firstname | Surname | Email address |
$fieldarray = array();
if($formdata=$dbcnx->query("SELECT Field_ID, FieldDesc FROM forms where ptitle = '$pageid' && ptitle2='$subpageid' && ptitle3='$ssubpageid' order by Orde ASC")){
while($formdisplay=$formdata->fetch_assoc()){
$fieldid = $formdisplay["Field_ID"];
$fielddesc = htmlentities($formdisplay["FieldDesc"], ENT_QUOTES, "ISO-8859-1");
echo("$fielddesc | ");
$fieldarray[]=$fieldid;
}
$formdata->close();
}
?>
|---|
if($formdata=$dbcnx->query("SELECT * FROM formresponse where ptitle = '$pageid' && ptitle2='$subpageid' && ptitle3='$ssubpageid' order by responseid ASC")){
while($formdisplay=$formdata->fetch_assoc()){
$responseid = $formdisplay["responseid"];
$resptitle = $formdisplay["resptitle"];
$respfirstname = $formdisplay["respfirstname"];
$respsurname = $formdisplay["respsurname"];
$emailaddy = $formdisplay["emailaddy"];
echo("| $responseid | $resptitle | $respfirstname | $respsurname | $emailaddy | ");
foreach ($fieldarray as $value) {
$dynarrayfield = stripslashes($formdisplay["$value"]);
echo("$dynarrayfield | ");
}
echo("
");
}
$formdata->close();
}
?>