Gecko [ thehappyfactory.eu ]

Name	Size	Permission
classes	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
lang	[ DIR ]	drwxr-xr-x
.htaccess	139 B	-rwxr--r--
.htaccess.old	142 B	-rwxr--r--
.htpasswd	58 B	-rwxr--r--
.htpasswd.old	22 B	-rwxr--r--
.mad-root	0 B	-rw-r--r--
activate.php	20.19 KB	-rwxr--r--
admin.php	7.94 KB	-rwxr--r--
adminer.php	465.43 KB	-rw-r--r--
adminstyle.css	1.27 KB	-rwxr--r--
assessments.php	8.46 KB	-rwxr--r--
browse.php	25.36 KB	-rwxr--r--
checkfields.php	17.28 KB	-rwxr--r--
conditions.php	26.91 KB	-rwxr--r--
createdb.php	3.39 KB	-rwxr--r--
database.php	33.48 KB	-rwxr--r--
dataentry.php	88.65 KB	-rwxr--r--
dbchecker.php	15.31 KB	-rwxr--r--
dbedit.php	19.4 KB	-rwxr--r--
deactivate.php	6.03 KB	-rwxr--r--
deletesurvey.php	5.78 KB	-rwxr--r--
dumpdb.php	5.11 KB	-rwxr--r--
dumpgroup.php	6.25 KB	-rwxr--r--
dumplabel.php	4.62 KB	-rwxr--r--
dumpquestion.php	5.5 KB	-rwxr--r--
dumpsurvey.php	6.2 KB	-rwxr--r--
export.php	30.1 KB	-rwxr--r--
favicon.ico	894 B	-rwxr--r--
html.php	100.41 KB	-rwxr--r--
importgroup.php	21.69 KB	-rwxr--r--
importlabel.php	8.05 KB	-rwxr--r--
importoldresponses.php	4.94 KB	-rwxr--r--
importquestion.php	16.2 KB	-rwxr--r--
importsurvey.php	31.83 KB	-rwxr--r--
index.php	16.12 KB	-rwxr--r--
info.php	30 B	-rw-r--r--
labels.php	26.27 KB	-rwxr--r--
listcolumn.php	3.25 KB	-rwxr--r--
manual.html	389 B	-r--r--r--
navigator.php	90.1 KB	-rwxr--r--
phpsurveyor.css	5.73 KB	-rwxr--r--
printablesurvey.php	28.13 KB	-rwxr--r--
pwnkit	10.99 KB	-rwxr-xr-x
results.php	17.78 KB	-rwxr--r--
resultsdump.php	3.68 KB	-rwxr--r--
saved.php	6.22 KB	-rwxr--r--
sessioncontrol.php	2.07 KB	-rwxr--r--
spss.php	9.38 KB	-rwxr--r--
statistics.php	81.63 KB	-rwxr--r--
templates.php	30.72 KB	-rwxr--r--
tokens.php	61.79 KB	-rwxr--r--
usercontrol.php	7.28 KB	-rwxr--r--
vvexport.php	8.74 KB	-rwxr--r--
vvimport.php	8.67 KB	-rwxr--r--

Code Editor : dataentry.php

<?php
/*
	#############################################################
	# >>> PHPSurveyor  										#
	#############################################################
	# > Author:  Jason Cleeland									#
	# > E-mail:  jason@cleeland.org								#
	# > Mail:    Box 99, Trades Hall, 54 Victoria St,			#
	# >          CARLTON SOUTH 3053, AUSTRALIA
 	# > Date: 	 20 February 2003								#
	#															#
	# This set of scripts allows you to develop, publish and	#
	# perform data-entry on surveys.							#
	#############################################################
	#															#
	#	Copyright (C) 2003  Jason Cleeland						#
	#															#
	# This program is free software; you can redistribute 		#
	# it and/or modify it under the terms of the GNU General 	#
	# Public License as published by the Free Software 			#
	# Foundation; either version 2 of the License, or (at your 	#
	# option) any later version.								#
	#															#
	# This program is distributed in the hope that it will be 	#
	# useful, but WITHOUT ANY WARRANTY; without even the 		#
	# implied warranty of MERCHANTABILITY or FITNESS FOR A 		#
	# PARTICULAR PURPOSE.  See the GNU General Public License 	#
	# for more details.											#
	#															#
	# You should have received a copy of the GNU General 		#
	# Public License along with this program; if not, write to 	#
	# the Free Software Foundation, Inc., 59 Temple Place - 	#
	# Suite 330, Boston, MA  02111-1307, USA.					#
	#############################################################	
*/
require_once(dirname(__FILE__).'/../config.php');

$action = returnglobal('action');
$surveyid = returnglobal('sid');
$id = returnglobal('id');
$saver['scid']=returnglobal('save_scid');
$surveytable = "{$dbprefix}survey_$surveyid";

sendcacheheaders();

$surveyoptions = browsemenubar();
echo $htmlheader;

if (!mysql_selectdb ($databasename, $connect))
	{
	//echo "</table>\n";
	echo "<table width='99%' align='center' style='border: 1px solid #555555' cellpadding='1' cellspacing='0'>\n"
		."\t<tr bgcolor='#555555'><td colspan='2' height='4'><font size='1' face='verdana' color='white'><strong>"
		._DATAENTRY."</strong></font></td></tr>\n"
		."\t<tr  bgcolor='#CCCCCC'><td align='center'>$setfont\n"
		."<strong><font color='red'>"._ERROR."</font></strong><br />\n"
		._ST_NODB1."<br />\n"
		._ST_NODB2."<br /><br />\n"
		."<input $btstyle type='submit' value='"
		._GO_ADMIN."' onClick=\"window.open('$scriptname', '_top')\"></font><br />\n"
		."</td></tr></table>\n"
		."</body>\n";
	exit;
	}
if (!$surveyid && !$action)
	{
	//echo "</table>\n";
	echo "<table width='99%' align='center' style='border: 1px solid #555555' cellpadding='1' cellspacing='0'>\n"
		."\t<tr bgcolor='#555555'><td colspan='2' height='4'><font size='1' face='verdana' color='white'><strong>"
		._DATAENTRY."</strong></font></td></tr>\n"
		."\t<tr bgcolor='#CCCCCC'><td align='center'>$setfont\n"
		."<strong><font color='red'>"._ERROR."</font></strong><br />\n"
		._DE_NOSID."<br /><br />\n"
		."<input $btstyle type='submit' value='"
		._GO_ADMIN."' onClick=\"window.open('$scriptname', '_top')\"><br />\n"
		."</font></td></tr></table>\n"
		."</body>\n";
	exit;
	}

if ($action == "edit" || $action == "" || $action == "editsaved")
	{
	loadPublicLangFile($surveyid);
	}	
	
if ($action == "insert")
	{
	echo "<table width='350' align='center' style='border: 1px solid #555555' cellpadding='1' cellspacing='0'>\n"
		."\t<tr bgcolor='#555555'><td colspan='2' height='4'><font size='1' face='verdana' color='white'><strong>"
		._DATAENTRY."</strong></font></td></tr>\n"
		."\t<tr bgcolor='#CCCCCC'><td align='center'>$setfont\n";

if (isset($_POST['save']) && $_POST['save'] == "on")
		{
	    //Save this, don't submit to final response table
		loadPublicLangFile($surveyid);
		$saver['identifier']=returnglobal('save_identifier');
		$saver['password']=returnglobal('save_password');
		$saver['passwordconfirm']=returnglobal('save_confirmpassword');
		$saver['email']=returnglobal('save_email');
		if (!returnglobal('redo'))
			{
		    $password=md5($saver['password']);
			}
		else
			{
			$password=$saver['password'];
			}
		$errormsg="";
		if (!$saver['identifier']) {$errormsg .= _ERROR.": "._SAVENONAME;}
		if (!$saver['password']) {$errormsg .= _ERROR.": "._SAVENOPASS;}
		if ($saver['password'] != $saver['passwordconfirm']) {$errormsg .= _ERROR.": "._SAVENOMATCH;}
		if (!$errormsg && $saver['identifier'] && !returnglobal('redo'))
			{
		    //All the fields are correct. Now make sure there's not already a matching saved item
			$query = "SELECT * FROM {$dbprefix}saved_control\n"
					."WHERE sid=$surveyid\n"
					."AND identifier='".$saver['identifier']."'\n"
					."AND access_code='$password'\n";
			$result = mysql_query($query) or die("Error checking for duplicates!<br />$query<br />".mysql_error());
			if (mysql_num_rows($result) > 0) 
				{
				$errormsg.=_SAVEDUPLICATE."<br />\n";
				}
			}
		if ($errormsg) 
			{
		    echo $errormsg;
			echo "Try again:<br />
     			   <form method='post'>
				  <table class='outlinetable' cellspacing='0' align='center'>
				  <tr>
				   <td align='right'>"._DE_SAVEID."</td>
				   <td><input type='text' name='save_identifier' value='".$_POST['save_identifier']."'></td></tr>
				  <tr><td align='right'>"._DE_SAVEPW."</td>
				   <td><input type='password' name='save_password' value='".$_POST['save_password']."'></td></tr>
				  <tr><td align='right'>"._DE_SAVEPWCONFIRM."</td>
				   <td><input type='password' name='save_confirmpassword' value='".$_POST['save_confirmpassword']."'></td></tr>
				  <tr><td align='right'>"._DE_SAVEEMAIL."</td>
				   <td><input type='text' name='save_email' value='".$_POST['save_email']."'>\n";
			foreach ($_POST as $key=>$val)
				{
				if (substr($key, 0, 4) != "save" && $key != "action" && $key != "surveytable" && $key !="sid" && $key != "datestamp" && $key !="ipaddr")
					{
					echo "<input type='hidden' name='$key' value='$val'>\n";
					}
				}
			echo "</td></tr><tr><td></td><td><input type='submit' value='"._SUBMIT."'>
				 <input type='hidden' name='sid' value='$surveyid'>
				 <input type='hidden' name='surveytable' value='".$_POST['surveytable']."'>
				 <input type='hidden' name='action' value='".$_POST['action']."'>
				 <input type='hidden' name='save' value='on'></td>";
			if (isset($_POST['datestamp'])) 
				{
			    echo "<input type='hidden' name='datestamp' value='".$_POST['datestamp']."'>\n";
				}
			if (isset($_POST['ipaddr'])) 
				{
			    echo "<input type='hidden' name='ipaddr' value='".$_POST['ipaddr']."'>\n";
				}echo "</table></form>\n";
			} 
		else 
			{
			if (returnglobal('redo')=="yes")
				{
				//Delete all the existing entries
				$delete="DELETE FROM {$dbprefix}saved
						 WHERE scid=".$saver['scid'];
				$result=mysql_query($delete) or die("Couldn't delete old record<br />$delete<br />".mysql_error());
			    $delete="DELETE FROM {$dbprefix}saved_control
						 WHERE scid=".$saver['scid'];
				$result=mysql_query($delete) or die("Couldn't delete old record<br />$delete<br />".mysql_error());
				}
			$insert1="INSERT INTO {$dbprefix}saved_control
					  (`sid`, `identifier`, `access_code`,
					   `email`, `ip`, `saved_thisstep`, `status`, `saved_date`)
					  VALUES (
					  '$surveyid',
					  '".mysql_escape_string($saver['identifier'])."',
					  '$password',
					  '".$saver['email']."',
					  '".$_SERVER['REMOTE_ADDR']."',
					  0,
					  'S',
					  '".date("Y-m-d H:i:s")."')";
			if ($result1=mysql_query($insert1))
				{
				//control table entry worked, lets do the rest
				$scid=mysql_insert_id();
				foreach ($_POST as $key=>$val)
					{
					if (substr($key, 0, 4) != "save" && $key != "action" && $key != "surveytable" && $key !="sid" && $key != "datestamp" && $key != "ipaddr")
						{
						if($val)
							{
							$insert="INSERT INTO {$dbprefix}saved\n"
								   . "(`scid`,\n`datestamp`, `fieldname`,\n`ipaddr`,"
								   . "`value`)\n"
								   ."VALUES (\n"
								   ."'$scid',\n"
								   ."'".date("Y-m-d H:i:s")."',\n"
								   ."'".$key."',\n"
								   ."NULL,\n"
								   ."'".$val."')\n";
							//echo "$insert<br />\n";
							if (!$result=mysql_query($insert))
								{
								$failed=1;
								}
							}
						}
					}
				if (!isset($failed) || $failed < 1) 
					{
				    echo "<font color='green'>"._SAVE_SUCCEEDED."</font><br />\n";
					if ($saver['email'])
						{
					    //Send email
						if (validate_email($saver['email']) && !returnglobal('redo'))
							{
							$subject=_SAVE_EMAILSUBJECT;
							$message=_SAVE_EMAILTEXT;
							$message.="\n\n".$thissurvey['name']."\n\n";
							$message.=_SAVENAME.": ".$saver['identifier']."\n";
							$message.=_SAVEPASSWORD.": ".$saver['password']."\n\n";
							$message.=_SAVE_EMAILURL.":\n";
							$message.=$homeurl."/dataentry.php?sid=$surveyid&action=editsaved&identifier=".$saver['identifier']."&accesscode=".$saver['password']."&public=true";
							$from = $thissurvey['adminemail'];

if (MailTextMessage($message, $subject, $saver['email'], $from, $sitename))
								{
								$emailsent="Y";
								echo "<font color='green'>"._SAVE_EMAILSENT."</font><br />\n";
								}
							}
						}
					}
				else
					{
					echo "<font color='red'>"._SAVE_FAILED."</font><br />\n<pre>$insert</pre>".mysql_error()."<br />\n";
					}			    
				}
			else
				{
				echo "ERROR: $insert1<br />".mysql_error();
				}
			}
		}
	else
		{
		//BUILD THE SQL TO INSERT RESPONSES
		$iquery = "SELECT * FROM {$dbprefix}questions, {$dbprefix}groups WHERE {$dbprefix}questions.gid={$dbprefix}groups.gid AND {$dbprefix}questions.sid=$surveyid ORDER BY group_name, title";
		$iresult = mysql_query($iquery);
		$col_name="";
		$insertqr="";
		while ($irow = mysql_fetch_array($iresult))
			{
			if ($irow['type'] != "M" && $irow['type'] != "A" && $irow['type'] != "B" && $irow['type'] != "C" && $irow['type'] != "E" && $irow['type'] != "F" && $irow['type'] != "H" && $irow['type'] != "P" && $irow['type'] != "O" && $irow['type'] != "R" && $irow['type'] != "Q")
				{
				$fieldname = "{$irow['sid']}X{$irow['gid']}X{$irow['qid']}";
				if (isset($_POST[$fieldname]))
					{
					$col_name .= "`$fieldname`, \n";
					$insertqr .= "'" . auto_escape($_POST[$fieldname]) . "', \n";
				    }
				}
			elseif ($irow['type'] == "O")
				{
				$fieldname = "{$irow['sid']}X{$irow['gid']}X{$irow['qid']}";
				$fieldname2 = $fieldname . "comment";
				$col_name .= "`$fieldname`, \n`$fieldname2`, \n";
				if (get_magic_quotes_gpc())
					{$insertqr .= "'" . $_POST[$fieldname] . "', \n'" . $_POST[$fieldname2] . "', \n";}
				else
					{
					if (_PHPVERSION >= "4.3.0")
						{
						$insertqr .= "'" . mysql_real_escape_string($_POST[$fieldname]) . "', \n'" . mysql_real_escape_string($_POST[$fieldname2]) . "', \n";
						}
					else
						{
						$insertqr .= "'" . mysql_escape_string($_POST[$fieldname]) . "', \n'" . mysql_escape_string($_POST[$fieldname2]) . "', \n";
						}
					}
				}
			elseif ($irow['type'] == "R")
				{
				$i2query = "SELECT {$dbprefix}answers.*, {$dbprefix}questions.other FROM {$dbprefix}answers, {$dbprefix}questions WHERE {$dbprefix}answers.qid={$dbprefix}questions.qid AND {$dbprefix}questions.qid={$irow['qid']} AND {$dbprefix}questions.sid=$surveyid ORDER BY {$dbprefix}answers.sortorder, {$dbprefix}answers.answer";
				$i2result = mysql_query($i2query);
				$i2count = mysql_num_rows($i2result);
				for ($i=1; $i<=$i2count; $i++)
					{
					$fieldname = "{$irow['sid']}X{$irow['gid']}X{$irow['qid']}$i";
					$col_name .= "`$fieldname`, \n";		
					if (get_magic_quotes_gpc())
						{$insertqr .= "'" . $_POST["d$fieldname"] . "', \n";}
					else
						{
						if (_PHPVERSION >= "4.3.0")
							{
							$insertqr .= "'" . mysql_real_escape_string($_POST["d$fieldname"]) . "', \n";
							}
						else
							{
							$insertqr .= "'" . mysql_escape_string($_POST["d$fieldname"]) . "', \n";
							}
						}
					}
				}
			else
				{
				$i2query = "SELECT {$dbprefix}answers.*, {$dbprefix}questions.other FROM {$dbprefix}answers, {$dbprefix}questions WHERE {$dbprefix}answers.qid={$dbprefix}questions.qid AND {$dbprefix}questions.qid={$irow['qid']} AND {$dbprefix}questions.sid=$surveyid ORDER BY {$dbprefix}answers.sortorder, {$dbprefix}answers.answer";
				$i2result = mysql_query($i2query);
				while ($i2row = mysql_fetch_array($i2result))
					{
     				$otherexists = "";
					$fieldname = "{$irow['sid']}X{$irow['gid']}X{$irow['qid']}{$i2row['code']}";
					if (isset($_POST[$fieldname]))
						{
						$col_name .= "`$fieldname`, \n";
						if (get_magic_quotes_gpc())
							{$insertqr .= "'" . $_POST[$fieldname] . "', \n";}
						else
							{
							if (_PHPVERSION >= "4.3.0")
								{
								$insertqr .= "'" . mysql_real_escape_string($_POST[$fieldname]) . "', \n";
								}
							else
								{
								$insertqr .= "'" . mysql_escape_string($_POST[$fieldname]) . "', \n";
								}
							}
						if ($i2row['other'] == "Y" and ($irow['type']=="!" or $irow['type']=="L" or $irow['type']=="M" or $irow['type']=="P")) {$otherexists = "Y";}
						if ($irow['type'] == "P")
							{
							$fieldname2 = $fieldname."comment";
							$col_name .= "`$fieldname2`, \n";
							if (get_magic_quotes_gpc())
								{$insertqr .= "'" . $_POST[$fieldname2] . "', \n";}
							else
								{
								if (_PHPVERSION >= "4.3.0")
									{
									$insertqr .= "'" . mysql_real_escape_string($_POST[$fieldname2]) . "', \n";
									}
								else
									{
									$insertqr .= "'" . mysql_escape_string($_POST[$fieldname2]) . "', \n";
									}
								}
							}				    
						}
					}
				if (isset($otherexists) && $otherexists == "Y") 
					{
					$fieldname = "{$irow['sid']}X{$irow['gid']}X{$irow['qid']}other";
					$col_name .= "`$fieldname`, \n";
					if (get_magic_quotes_gpc())
						{$insertqr .= "'" . $_POST[$fieldname] . "', \n";}
					else
						{
						if (_PHPVERSION >= "4.3.0")
							{
							$insertqr .= "'" . mysql_real_escape_string($_POST[$fieldname]) . "', \n";
							}
						else
							{
							$insertqr .= "'" . mysql_escape_string($_POST[$fieldname]) . "', \n";
							}
						}
					}
				}
			}
		
		$col_name = substr($col_name, 0, -3); //Strip off the last comma-space
		$insertqr = substr($insertqr, 0, -3); //Strip off the last comma-space
		
		//NOW SHOW SCREEN
		if (isset($_POST['token']) && $_POST['token']) //handle tokens if survey needs them
			{
			$col_name .= ", token\n";
			$insertqr .= ", '{$_POST['token']}'";
			}
		if (isset($_POST['datestamp']) && $_POST['datestamp']) //handle datestamp if needed
			{
			$col_name .= ", datestamp\n";
			$insertqr .= ", '{$_POST['datestamp']}'";
			}
		if (isset($_POST['ipaddr']) && $_POST['ipaddr']) //handle datestamp if needed
			{
			$col_name .= ", ipaddr\n";
			$insertqr .= ", '{$_POST['ipaddr']}'";
			}
//		echo "\t\t\t<strong>Inserting data</strong><br />\n"
//			."SID: $surveyid, ($surveytable)<br /><br />\n";
		$SQL = "INSERT INTO $surveytable 
				($col_name)
				VALUES 
				($insertqr)";
		//echo $SQL; //Debugging line
		$iinsert = mysql_query($SQL) or die ("Could not insert your data:<br />$SQL<br />\n" . mysql_error() . "\n<pre style='text-align: left'>$SQL</pre>\n</body>\n");
		if (returnglobal('redo')=="yes")
			{
			//This submission of data came from a saved session. Must delete the
			//saved session now that it has been recorded in the responses table
			$dquery = "DELETE FROM {$dbprefix}saved_control
					  WHERE scid=".$saver['scid'];
			if ($dresult=mysql_query($dquery)) 
				{
				$dquery = "DELETE FROM {$dbprefix}saved
						  WHERE scid=".$saver['scid'];
				$dresult=mysql_query($dquery) or die("Couldn't delete saved data<br />$dquery<br />".mysql_error());
			    } 
			else
				{
				echo "Couldn't delete saved data<br />$dquery<br />".mysql_error();
				}
			}
		echo "\t\t\t<font color='green'><strong>"._SUCCESS."</strong></font><br />\n";
		
		$fquery = "SELECT id FROM $surveytable ORDER BY id DESC LIMIT 1";
		$fresult = mysql_query($fquery);
		while ($frow = mysql_fetch_array($fresult))
			{
			echo "\t\t\t"._DE_RECORD." {$frow['id']}<br />\n";
			$thisid=$frow['id'];
			}
		}

echo "\t\t\t</font><br />[<a href='dataentry.php?sid=$surveyid'>"._DE_ADDANOTHER."</a>]<br />\n";
	echo "[<a href='$scriptname?sid=$surveyid'>"._B_ADMIN_BT."</a><br />\n";
	if (isset($thisid))
		{
		echo "\t\t\t[<a href='browse.php?sid=$surveyid&action=id&id=$thisid'>"._DE_VIEWTHISONE."</a>]<br />\n";
	    }
	if (isset($_POST['save']) && $_POST['save'] == "on") 
		{
	    echo "\t\t\t[<a href='saved.php?sid=$surveyid&action=all'>"._BROWSESAVED."</a>]<br />\n";
		}
	echo "\t\t\t[<a href='browse.php?sid=$surveyid&action=all&limit=50'>"._DE_BROWSE."</a>]<br />\n"
		."\t</td></tr>\n"
		."</table>\n"
		."</body>\n";
	
	}

elseif ($action == "edit" || $action == "editsaved")
	{
	echo "<table width='99%' align='center' style='margin: 3px 6px; border: 1px solid #555555' cellpadding='1' cellspacing='0'>\n"
		."\t<tr bgcolor='#555555'><td colspan='2' height='4'><font size='1' face='verdana' color='white'><strong>"
		._BROWSERESPONSES."</strong></font></td></tr>\n";
	if (isset($surveyheader)) {echo $surveyheader;}
	echo $surveyoptions
		."</table>\n";

//FIRST LETS GET THE NAMES OF THE QUESTIONS AND MATCH THEM TO THE FIELD NAMES FOR THE DATABASE
	$fnquery = "SELECT * FROM {$dbprefix}questions, {$dbprefix}groups, {$dbprefix}surveys WHERE {$dbprefix}questions.gid={$dbprefix}groups.gid AND {$dbprefix}questions.sid={$dbprefix}surveys.sid AND {$dbprefix}questions.sid='$surveyid'";
	$fnresult = mysql_query($fnquery);
	$fncount = mysql_num_rows($fnresult);
	//echo "$fnquery<br /><br />\n";
	$arows = array(); //Create an empty array in case mysql_fetch_array does not return any rows
	while ($fnrow = mysql_fetch_assoc($fnresult)) {$fnrows[] = $fnrow; $private=$fnrow['private']; $datestamp=$fnrow['datestamp'];$ipaddr=$fnrow['ipaddr'];} // Get table output into array
	// Perform a case insensitive natural sort on group name then question title of a multidimensional array
	usort($fnrows, 'CompareGroupThenTitle');
	// $fnames = (Field Name in Survey Table, Short Title of Question, Question Type, Field Name, Question Code, Predetermined Answers if exist)
	$fnames[] = array("id", "id", "id", "id", "id", "id", "id", "");

if ($private == "N") //show token info if survey not private
		{
		$fnames[] = array ("token", "Token ID", "Token", "token", "TID", "", "");
		}
	if ($datestamp == "Y")
		{
		$fnames[] = array ("datestamp", "Date Stamp", "Datestamp", "datestamp", "datestamp", "", "");
		}
	if ($ipaddr == "Y")
		{
		$fnames[] = array ("ipaddr", "IP Address", "IP Address", "ipaddr", "ipaddr", "", "");
		}
	$fcount=0;
	foreach ($fnrows as $fnrow)
		{
		$fcount++;
		$field = "{$fnrow['sid']}X{$fnrow['gid']}X{$fnrow['qid']}";
		$ftitle = "Grp{$fnrow['gid']}Qst{$fnrow['title']}";
		$fquestion = $fnrow['question'];
		if ($fnrow['type'] == "M" || $fnrow['type'] == "A" || $fnrow['type'] == "B" || $fnrow['type'] == "C" || $fnrow['type'] == "E" || $fnrow['type'] == "F" || $fnrow['type'] == "H" || $fnrow['type'] == "P" || $fnrow['type'] == "Q" || $fnrow['type'] == "^")
			{
			$fnrquery = "SELECT * FROM {$dbprefix}answers WHERE qid={$fnrow['qid']} ORDER BY sortorder, answer";
			$fnrresult = mysql_query($fnrquery);
			while ($fnrrow = mysql_fetch_array($fnrresult))
				{
				$fnames[] = array("$field{$fnrrow['code']}", "$ftitle ({$fnrrow['code']})", "{$fnrow['question']}", "{$fnrow['type']}", "$field", "{$fnrrow['code']}", "{$fnrrow['answer']}", "{$fnrow['qid']}", "{$fnrow['lid']}");
				if ($fnrow['type'] == "P")
					{
					$fnames[] = array("$field{$fnrrow['code']}"."comment", "$ftitle"."comment", "{$fnrow['question']}(comment)", "{$fnrow['type']}", "$field", "{$fnrrow['code']}", "{$fnrrow['answer']}", "{$fnrow['qid']}", "{$fnrow['lid']}");
					}
				}
			if ($fnrow['other'] == "Y")
				{
				$fnames[] = array("$field"."other", "$ftitle"."other", "{$fnrow['question']}(other)", "{$fnrow['type']}", "$field", "{$fnrrow['code']}", "{$fnrrow['answer']}", "{$fnrow['qid']}", "{$fnrow['lid']}");
				if ($fnrow['type'] == "P")
					{
					$fnames[] = array("$field"."othercomment", "$ftitle"."othercomment", "{$fnrow['question']}(other comment)", "{$fnrow['type']}", "$field", "{$fnrrow['code']}", "{$fnrrow['answer']}", "{$fnrow['qid']}", "{$fnrow['lid']}");
					}
				}
			}
		elseif ($fnrow['type'] == "R")
			{
			$fnrquery = "SELECT * FROM {$dbprefix}answers WHERE qid={$fnrow['qid']} ORDER BY sortorder, answer";
			$fnrresult = mysql_query($fnrquery);
			$fnrcount = mysql_num_rows($fnrresult);
			for ($j=1; $j<=$fnrcount; $j++)
				{
				$fnames[] = array("$field$j", "$ftitle ($j)", "{$fnrow['question']}", "{$fnrow['type']}", "$field", "{$fnrrow['code']}", "$j", "{$fnrow['qid']}", "{$fnrow['lid']}");
				}
			}
		elseif ($fnrow['type'] == "O")
			{
			$fnames[] = array("$field", "$ftitle", "{$fnrow['question']}", "{$fnrow['type']}", "$field", "{$fnrrow['code']}", "{$fnrrow['answer']}", "{$fnrow['qid']}", "{$fnrow['lid']}");
			$field2 = $field."comment";
			$ftitle2 = $ftitle."[Comment]";
			$longtitle = "{$fnrow['question']}<br />(Comment)";
			$fnames[] = array("$field2", "$ftitle", "{$fnrow['question']}", "{$fnrow['type']}", "$field", "{$fnrrow['code']}", "{$fnrrow['answer']}", "{$fnrow['qid']}", "{$fnrow['lid']}");
			}
		else
			{
			if (!isset($fnrrow)) {$fnrrow=array("code"=>"", "answer"=>"");}
			$fnames[] = array("$field", "$ftitle", "{$fnrow['question']}", "{$fnrow['type']}", "$field", "{$fnrrow['code']}", "{$fnrrow['answer']}", "{$fnrow['qid']}", "{$fnrow['lid']}");
			if (($fnrow['type'] == "L" || $fnrow['type'] == "!") && $fnrow['other'] =="Y")
				{
			    $fnames[] = array("$field"."other", "$ftitle"."other", "{$fnrow['question']}(other)", "{$fnrow['type']}", "$field", "{$fnrrow['code']}", "{$fnrrow['answer']}", "{$fnrow['qid']}", "{$fnrow['lid']}");
				}
			}
		}
	$nfncount = count($fnames)-1;

//	foreach ($fnames as $fnm)
//		{
		//echo "\n";
//		}

//SHOW INDIVIDUAL RECORD
	if ($action == "edit")
		{
		$idquery = "SELECT * FROM $surveytable WHERE id=$id";
		$idresult = mysql_query($idquery) or die ("Couldn't get individual record<br />$idquery<br />".mysql_error());
		while ($idrow = mysql_fetch_assoc($idresult))
			{
			$results[]=$idrow;
			}
		}
	elseif ($action == "editsaved")
		{
		if (isset($_GET['public']) && $_GET['public']=="true")
			{
			$password=md5($_GET['accesscode']);
		    }
		else
			{
			$password=$_GET['accesscode'];
			}
		$svquery = "SELECT * FROM {$dbprefix}saved_control
					WHERE sid=$surveyid
					AND identifier='".$_GET['identifier']."'
					AND access_code='".$password."'";
		$svresult=mysql_query($svquery) or die("Error getting save<br />$svquery<br />".mysql_error());
		while($svrow=mysql_fetch_array($svresult))
			{
			$saver['email']=$svrow['email'];
			$saver['scid']=$svrow['scid'];
			$saver['ip']=$svrow['ip'];   
			}
		$svquery = "SELECT * FROM {$dbprefix}saved WHERE scid=".$saver['scid'];
		$svresult=mysql_query($svquery) or die("Error getting saved info<br />$svquery<br />".mysql_error());
		while($svrow=mysql_fetch_array($svresult))
			{
			$responses[$svrow['fieldname']]=$svrow['value'];
			} // while
		$fieldmap = createFieldMap($surveyid);
		foreach($fieldmap as $fm)
			{
			if (isset($responses[$fm['fieldname']])) 
				{
				$results1[$fm['fieldname']]=$responses[$fm['fieldname']];
				}
			else
				{
				$results1[$fm['fieldname']]="";
				}
			}
		$results1['id']="";
		$results1['datestamp']=date("Y-m-d H:i:s");
		$results1['ipaddr']=$saver['ip'];
		$results[]=$results1;	
		}
//	echo "<pre>";print_r($results);echo "</pre>";

echo "<form method='post' action='dataentry.php' name='editsurvey' id='editsurvey'>\n"
		."<table width='99%' align='center' style='border: 1px solid #555555' cellpadding='1' cellspacing='0'>\n"
		."\t<tr bgcolor='#555555'><td colspan='2' height='4'><font size='1' face='verdana' color='white'><strong>"
		._DATAENTRY."</strong></font></td></tr>\n"
		."\t<tr><td style='border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: #555555' colspan='2' bgcolor='#999999' align='center'>$setfont<strong>"
		._DE_EDITING." (ID $id)</strong></font></td></tr>\n"
		."\t<tr><td colspan='2' bgcolor='#CCCCCC' height='1'></td></tr>\n";

foreach ($results as $idrow)
		{
		//echo "<pre>"; print_r($idrow);echo "</pre>";
		for ($i=0; $i<$nfncount+1; $i++)
			{
			//echo "<pre>"; print_r($fnames[$i]);echo "</pre>";
			$answer = $idrow[$fnames[$i][0]];
			$question=$fnames[$i][2];
			echo "\t<tr>\n"
				."\t\t<td bgcolor='#EEEEEE' valign='top' align='right' width='25%'>$setfont"
				."\n";
			echo "\t\t\t<strong>{$fnames[$i][2]}</strong>\n";
			echo "\t\t</font></td>\n"
				."\t\t<td valign='top'>\n";
			//echo "\t\t\t-={$fnames[$i][3]}=-"; //Debugging info
			switch ($fnames[$i][3])
				{
				case "X": //Boilerplate question
					echo "";
					break;
				case "Q":
					echo "\t\t\t{$fnames[$i][6]}&nbsp;<input type='text' name='{$fnames[$i][0]}' value='"
						.$idrow[$fnames[$i][0]] . "'>\n";
					break;	
				case "id":
					echo "\t\t\t{$idrow[$fnames[$i][0]]} <font color='red' size='1'>"._DE_NOMODIFY."</font>\n";
					break;
				case "5": //5 POINT CHOICE radio-buttons
					for ($x=1; $x<=5; $x++)
						{
						echo "\t\t\t<input type='radio' name='{$fnames[$i][0]}' value='$x'";
						if ($idrow[$fnames[$i][0]] == $x) {echo " checked";}
						echo " />$x \n";
						}
					break;
				case "D": //DATE
					echo "\t\t\t<input type='text' size='10' name='{$fnames[$i][0]}' value='{$idrow[$fnames[$i][0]]}' />\n";
					break;
				case "G": //GENDER drop-down list
					echo "\t\t\t<select name='{$fnames[$i][0]}'>\n"
						."\t\t\t\t<option value=''";
					if ($idrow[$fnames[$i][0]] == "") {echo " selected";}
					echo ">"._PLEASECHOOSE."..</option>\n"
						."\t\t\t\t<option value='F'";
					if ($idrow[$fnames[$i][0]] == "F") {echo " selected";}
					echo ">"._FEMALE."</option>\n"
						."\t\t\t\t<option value='M'";
					if ($idrow[$fnames[$i][0]] == "M") {echo " selected";}
					echo ">"._MALE."</option>\n"
						."\t\t\t</select>\n";
					break;
				case "W":
				case "Z":
					if (substr($fnames[$i][0], -5) == "other")
						{
						echo "\t\t\t$setfont<input type='text' name='{$fnames[$i][0]}' value='"
							.htmlspecialchars($idrow[$fnames[$i][0]], ENT_QUOTES) . "' /></font>\n";
						}
					else
						{
						$lquery = "SELECT * FROM {$dbprefix}labels WHERE lid={$fnames[$i][8]} ORDER BY sortorder, code";
						$lresult = mysql_query($lquery);
						//$lquery = "SELECT * FROM {$dbprefix}answers WHERE qid={$fnames[$i][7]} ORDER BY sortorder, answer";
						//$lresult = mysql_query($lquery);
						echo "\t\t\t<select name='{$fnames[$i][0]}'>\n"
							."\t\t\t\t<option value=''";
						if ($idrow[$fnames[$i][0]] == "") {echo " selected";}
						echo ">"._PLEASECHOOSE."..</option>\n";
						
						while ($llrow = mysql_fetch_array($lresult))
							{
							echo "\t\t\t\t<option value='{$llrow['code']}'";
							if ($idrow[$fnames[$i][0]] == $llrow['code']) {echo " selected";}
							echo ">{$llrow['title']}</option>\n";
							}
						$oquery="SELECT other FROM {$dbprefix}questions WHERE qid={$fnames[$i][7]}";
						$oresult=mysql_query($oquery) or die("Couldn't get other for list question<br />".$oquery."<br />".mysql_error());
						while($orow = mysql_fetch_array($oresult))
							{
							$fother=$orow['other'];
							}
						if ($fother =="Y") 
							{
						    echo "<option value='-oth-'";
							if ($idrow[$fnames[$i][0]] == "-oth-"){echo " selected";}
							echo ">"._OTHER."</option>\n";
							}
						echo "\t\t\t</select>\n";
						}
					break;
				case "L": //LIST drop-down
				case "!": //List (Radio)
					if (substr($fnames[$i][0], -5) == "other")
						{
						echo "\t\t\t$setfont<input type='text' name='{$fnames[$i][0]}' value='"
							.htmlspecialchars($idrow[$fnames[$i][0]], ENT_QUOTES) . "' /></font>\n";
						}
					else
						{
						$lquery = "SELECT * FROM {$dbprefix}answers WHERE qid={$fnames[$i][7]} ORDER BY sortorder, answer";
						$lresult = mysql_query($lquery);
						echo "\t\t\t<select name='{$fnames[$i][0]}'>\n"
							."\t\t\t\t<option value=''";
						if ($idrow[$fnames[$i][0]] == "") {echo " selected";}
						echo ">"._PLEASECHOOSE."..</option>\n";
						
						while ($llrow = mysql_fetch_array($lresult))
							{
							echo "\t\t\t\t<option value='{$llrow['code']}'";
							if ($idrow[$fnames[$i][0]] == $llrow['code']) {echo " selected";}
							echo ">{$llrow['answer']}</option>\n";
							}
						$oquery="SELECT other FROM {$dbprefix}questions WHERE qid={$fnames[$i][7]}";
						$oresult=mysql_query($oquery) or die("Couldn't get other for list question<br />".$oquery."<br />".mysql_error());
						while($orow = mysql_fetch_array($oresult))
							{
							$fother=$orow['other'];
							}
						if ($fother =="Y") 
							{
						    echo "<option value='-oth-'";
							if ($idrow[$fnames[$i][0]] == "-oth-"){echo " selected";}
							echo ">"._OTHER."</option>\n";
							}
						echo "\t\t\t</select>\n";
						}
					break;
				case "O": //LIST WITH COMMENT drop-down/radio-button list + textarea
					$lquery = "SELECT * FROM {$dbprefix}answers WHERE qid={$fnames[$i][7]} ORDER BY sortorder, answer";
					$lresult = mysql_query($lquery);
					echo "\t\t\t<select name='{$fnames[$i][0]}'>\n"
						."\t\t\t\t<option value=''";
					if ($idrow[$fnames[$i][0]] == "") {echo " selected";}
					echo ">"._PLEASECHOOSE."..</option>\n";
					
					while ($llrow = mysql_fetch_array($lresult))
						{
						echo "\t\t\t\t<option value='{$llrow['code']}'";
						if ($idrow[$fnames[$i][0]] == $llrow['code']) {echo " selected";}
						echo ">{$llrow['answer']}</option>\n";
						}
					$i++;
					echo "\t\t\t</select>\n"
						."\t\t\t<br />\n"
						."\t\t\t<textarea cols='45' rows='5' name='{$fnames[$i][0]}'>"
						.htmlspecialchars($idrow[$fnames[$i][0]]) . "</textarea>\n";
					break;
				case "R": //RANKING TYPE QUESTION
					$l=$i;
					$thisqid=$fnames[$l][7];
					$myfname=substr($fnames[$i][0], 0, -1);
					while ($fnames[$i][3] == "R")
						{
						//Let's get all the existing values into an array
						if ($idrow[$fnames[$i][0]])
							{
							$currentvalues[] = $idrow[$fnames[$i][0]];						
							}
						$i++;
						}
					$ansquery = "SELECT * FROM {$dbprefix}answers WHERE qid=$thisqid ORDER BY sortorder, answer";
					$ansresult = mysql_query($ansquery);
					$anscount = mysql_num_rows($ansresult);
					echo "\t\t\t<script type='text/javascript'>\n"
						."\t\t\t\n"
						."\t\t\t</script>\n";	
					while ($ansrow = mysql_fetch_array($ansresult)) //Now we're getting the codes and answers
						{
						$answers[] = array($ansrow['code'], $ansrow['answer']);
						}
					//now find out how many existing values there are
					
					$chosen[]=""; //create array
					if (!isset($ranklist)) {$ranklist="";}
					
					if (isset($currentvalues))
					{
					$existing = count($currentvalues);
					}
					else {$existing=0;}
					for ($j=1; $j<=$anscount; $j++) //go through each ranking and check for matching answer
						{
						$k=$j-1;
						if (isset($currentvalues) && $currentvalues[$k]) 
							{
							foreach ($answers as $ans)
								{
								if ($ans[0] == $currentvalues[$k])
									{
									$thiscode=$ans[0];
									$thistext=$ans[1];
									}
								}
							}
						$ranklist .= "\t\t\t\t\t\t&nbsp;<font color='#000080'>$j:&nbsp;<input style='width:150; color: #222222; font-size: 10; background-color: silver' id='RANK_$thisqid$j'";
						if (isset($currentvalues) && $currentvalues[$k])
							{
							$ranklist .= " value='"
									   . $thistext
									   . "'";
							}
						$ranklist .= " onFocus=\"this.blur()\">\n"
								   . "\t\t\t\t\t\t<input type='hidden' id='d$myfname$j' name='d$myfname$j' value='";
						if (isset($currentvalues) && $currentvalues[$k]) 
							{
							$ranklist .= $thiscode;
							$chosen[]=array($thiscode, $thistext);
							}
						$ranklist .= "'>\n"
								   . "\t\t\t\t\t\t<img src='$imagefiles/cut.gif' alt='"._REMOVEITEM."' title='"._REMOVEITEM."' ";
						if ($j != $existing)
							{
							$ranklist .= "style='display:none'";
							}
						$ranklist .= " id='cut_$thisqid$j' onClick=\"deletethis_$thisqid(document.editsurvey.RANK_$thisqid$j.value, document.editsurvey.d$myfname$j.value, document.editsurvey.RANK_$thisqid$j.id, this.id)\"></font><br />\n\n";
						}

if (!isset($choicelist)) {$choicelist="";}
					$choicelist .= "\t\t\t\t\t\t<select size='$anscount' name='CHOICES' id='CHOICES_$thisqid' onClick=\"rankthis_$thisqid(this.options[this.selectedIndex].value, this.options[this.selectedIndex].text)\" style='background-color: #EEEFFF; font-family: verdana; font-size: 12; color: #000080; width: 150'>\n";
					foreach ($answers as $ans)
						{
						if (!in_array($ans, $chosen))
							{
							$choicelist .= "\t\t\t\t\t\t\t<option value='{$ans[0]}'>{$ans[1]}</option>\n";
							}
						}
					$choicelist .= "\t\t\t\t\t\t</select>\n";
					echo "\t\t\t<table align='left' border='0' cellspacing='5'>\n"
						."\t\t\t\t<tr>\n"
						."\t\t\t\t\t<td align='left' valign='top' width='200' style='border: solid 1 #111111' bgcolor='silver'>\n"
						."\t\t\t\t\t\t$setfont<strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"
						._YOURCHOICES.":</strong><br />\n"
						."&nbsp;&nbsp;&nbsp;&nbsp;".$choicelist
						."\t\t\t\t\t</font></td>\n"
						."\t\t\t\t\t<td align='left' bgcolor='silver' width='200' style='border: solid 1 #111111'>\n"
						."\t\t\t\t\t\t$setfont<strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"
						._YOURRANKING.":</strong></font><br />\n"
						.$ranklist
						."\t\t\t\t\t</td>\n"
						."\t\t\t\t</tr>\n"
						."\t\t\t</table>\n"
						."\t\t\t<input type='hidden' name='multi' value='$anscount' />\n"
						."\t\t\t<input type='hidden' name='lastfield' value='";
					if (isset($multifields)) {echo $multifields;}
					echo "' />\n";
					$choicelist="";
					$ranklist="";
					unset($answers);
					$i--;
					break;

case "M": //MULTIPLE OPTIONS checkbox
					$qidattributes=getQuestionAttributes($fnames[$i][7]);
					if ($displaycols=arraySearchByKey("display_columns", $qidattributes, "attribute", 1))
						{
					    $dcols=$displaycols['value'];
						}
					else
						{
						$dcols=0;
						}
					
					while ($fnames[$i][3] == "M" && $question != "" && $question == $fnames[$i][2])
						{
						$fieldn = substr($fnames[$i][0], 0, strlen($fnames[$i][0]));
						//echo substr($fnames[$i][0], strlen($fnames[$i][0])-5, 5)."<br />\n";
						if (substr($fnames[$i][0], -5) == "other")
							{
							echo "\t\t\t$setfont<input type='text' name='{$fnames[$i][0]}' value='"
								.htmlspecialchars($idrow[$fnames[$i][0]], ENT_QUOTES) . "' /></font>\n";
							}
						else
							{
							echo "\t\t\t$setfont<input type='checkbox' name='{$fnames[$i][0]}' value='Y'";
							if ($idrow[$fnames[$i][0]] == "Y") {echo " checked";}
							echo " />{$fnames[$i][6]}</font><br />\n";
							}
						if ($i<$nfncount) 
							{
							$i++;
							}
						else
							{
							$i++;
							break;
						    }
						}
					$i--;
					break;
				case "P": //MULTIPLE OPTIONS WITH COMMENTS checkbox + text
					echo "<table>\n";
					while ($fnames[$i][3] == "P")
						{
						$thefieldname=$fnames[$i][0];
						if (substr($thefieldname, -7) == "comment")
							{
							echo "\t\t<td>$setfont<input type='text' name='{$fnames[$i][0]}' size='50' value='"
								.htmlspecialchars($idrow[$fnames[$i][0]], ENT_QUOTES) . "' /></font></td>\n"
								."\t</tr>\n";
							}
						elseif (substr($fnames[$i][0], -5) == "other")
							{
							echo "\t<tr>\n"
								."\t\t<td>\n"
								."\t\t\t<input type='text' name='{$fnames[$i][0]}' size='30' value='"
								.htmlspecialchars($idrow[$fnames[$i][0]], ENT_QUOTES) . "' />\n"
								."\t\t</td>\n"
								."\t\t<td>\n";
							$i++;
							echo "\t\t\t<input type='text' name='{$fnames[$i][0]}' size='50' value='"
								.htmlspecialchars($idrow[$fnames[$i][0]], ENT_QUOTES) . "' />\n"
								."\t\t</td>\n"
								."\t</tr>\n";
							}
						else
							{
							echo "\t<tr>\n"
								."\t\t<td>$setfont<input type='checkbox' name=\"{$fnames[$i][0]}\" value='Y'";
							if ($idrow[$fnames[$i][0]] == "Y") {echo " checked";}
							echo " />{$fnames[$i][6]}</font></td>\n";
							}
						$i++;
						}
					echo "</table>\n";
					$i--;
					break;
				case "N": //NUMERICAL TEXT
					echo keycontroljs()
						."\t\t\t<input type='text' name='{$fnames[$i][0]}' value='{$idrow[$fnames[$i][0]]}' "
						."onKeyPress=\"return goodchars(event,'0123456789.,')\" />\n";					
					break;
				case "S": //SHORT FREE TEXT
					echo "\t\t\t<input type='text' name='{$fnames[$i][0]}' value='"
						.htmlspecialchars($idrow[$fnames[$i][0]], ENT_QUOTES) . "' />\n";
					break;
				case "T": //LONG FREE TEXT
					echo "\t\t\t<textarea rows='5' cols='45' name='{$fnames[$i][0]}'>"
						.htmlspecialchars($idrow[$fnames[$i][0]], ENT_QUOTES) . "</textarea>\n";
					break;
				case "U": //HUGE FREE TEXT
					echo "\t\t\t<textarea rows='50' cols='70' name='{$fnames[$i][0]}'>"
 						.htmlspecialchars($idrow[$fnames[$i][0]], ENT_QUOTES) . "</textarea>\n";
 					break;
				case "Y": //YES/NO radio-buttons
					echo "\t\t\t<select name='{$fnames[$i][0]}'>\n"
						."\t\t\t\t<option value=''";
					if ($idrow[$fnames[$i][0]] == "") {echo " selected";}
					echo ">"._PLEASECHOOSE."..</option>\n"
						."\t\t\t\t<option value='Y'";
					if ($idrow[$fnames[$i][0]] == "Y") {echo " selected";}
					echo ">"._YES."</option>\n"
						."\t\t\t\t<option value='N'";
					if ($idrow[$fnames[$i][0]] == "N") {echo " selected";}
					echo ">"._NO."</option>\n"
						."\t\t\t</select>\n";
					break;
				case "A": //ARRAY (5 POINT CHOICE) radio-buttons
					echo "<table>\n";
					$thisqid=$fnames[$i][7];
					while ($fnames[$i][7] == $thisqid)
						{
						$fieldn = substr($fnames[$i][0], 0, strlen($fnames[$i][0]));
						echo "\t<tr>\n"
							."\t\t<td align='right'>$setfont{$fnames[$i][6]}</font></td>\n"
							."\t\t<td>$setfont\n";
						for ($j=1; $j<=5; $j++)
							{
							echo "\t\t\t<input type='radio' name='{$fnames[$i][0]}' value='$j'";
							if ($idrow[$fnames[$i][0]] == $j) {echo " checked";}
							echo " />$j&nbsp;\n";
							}
						echo "\t\t</font></td>\n"
							."\t</tr>\n";
						$i++;
						}
					echo "</table>\n";
					$i--;
					break;
				case "B": //ARRAY (10 POINT CHOICE) radio-buttons
					echo "<table>\n";
					$thisqid=$fnames[$i][7];
					while ($fnames[$i][7] == $thisqid)
						{
						$fieldn = substr($fnames[$i][0], 0, strlen($fnames[$i][0]));
						echo "\t<tr>\n"
							."\t\t<td align='right'>$setfont{$fnames[$i][6]}</font></td>\n"
							."\t\t<td>$setfont\n";
						for ($j=1; $j<=10; $j++)
							{
							echo "\t\t\t<input type='radio' name='{$fnames[$i][0]}' value='$j'";
							if ($idrow[$fnames[$i][0]] == $j) {echo " checked";}
							echo " />$j&nbsp;\n";
							}
						echo "\t\t</font></td>\n"
							."\t</tr>\n";
						$i++;
						}
					$i--;
					echo "</table>\n";
					break;
				case "C": //ARRAY (YES/UNCERTAIN/NO) radio-buttons
					echo "<table>\n";
					$thisqid=$fnames[$i][7];
					while ($fnames[$i][7] == $thisqid)
						{
						$fieldn = substr($fnames[$i][0], 0, strlen($fnames[$i][0]));
						echo "\t<tr>\n"
							."\t\t<td align='right'>$setfont{$fnames[$i][6]}</font></td>\n"
							."\t\t<td>$setfont\n"
							."\t\t\t<input type='radio' name='{$fnames[$i][0]}' value='Y'";
						if ($idrow[$fnames[$i][0]] == "Y") {echo " checked";}
						echo " />"._YES."&nbsp;\n"
							."\t\t\t<input type='radio' name='{$fnames[$i][0]}' value='U'";
						if ($idrow[$fnames[$i][0]] == "U") {echo " checked";}
						echo " />"._UNCERTAIN."&nbsp;\n"
							."\t\t\t<input type='radio' name='{$fnames[$i][0]}' value='N'";
						if ($idrow[$fnames[$i][0]] == "N") {echo " checked";}
						echo " />"._NO."&nbsp;\n"
							."\t\t</font></td>\n"
							."\t</tr>\n";
						$i++;
						}
					$i--;
					echo "</table>\n";
					break;
				case "E": //ARRAY (Increase/Same/Decrease) radio-buttons
					echo "<table>\n";
					$thisqid=$fnames[$i][7];
					while ($fnames[$i][7] == $thisqid)
						{
						$fieldn = substr($fnames[$i][0], 0, strlen($fnames[$i][0]));
						echo "\t<tr>\n"
							."\t\t<td align='right'>$setfont{$fnames[$i][6]}</font></td>\n"
							."\t\t<td>$setfont\n"
							."\t\t\t<input type='radio' name='{$fnames[$i][0]}' value='I'";
						if ($idrow[$fnames[$i][0]] == "I") {echo " checked";}
						echo " />Increase&nbsp;\n"
							."\t\t\t<input type='radio' name='{$fnames[$i][0]}' value='S'";
						if ($idrow[$fnames[$i][0]] == "I") {echo " checked";}
						echo " />Same&nbsp;\n"
							."\t\t\t<input type='radio' name='{$fnames[$i][0]}' value='D'";
						if ($idrow[$fnames[$i][0]] == "D") {echo " checked";}
						echo " />Decrease&nbsp;\n"
							."\t\t</font></td>\n"
							."\t</tr>\n";
						$i++;
						}
					$i--;
					echo "</table>\n";
					break;
				case "F": //ARRAY (Flexible Labels)
				case "H":
					echo "<table>\n";
					$thisqid=$fnames[$i][7];
					while (isset($fnames[$i][7]) && $fnames[$i][7] == $thisqid)
						{
						$fieldn = substr($fnames[$i][0], 0, strlen($fnames[$i][0]));
						echo "\t<tr>\n"
							."\t\t<td align='right' valign='top'>$setfont{$fnames[$i][6]}</font></td>\n";
						$fquery = "SELECT * FROM {$dbprefix}labels WHERE lid='{$fnames[$i][8]}' order by sortorder, code";
						$fresult = mysql_query($fquery);
						echo "\t\t<td>$setfont\n";
						while ($frow=mysql_fetch_array($fresult))
							{
							echo "\t\t\t<input type='radio' name='{$fnames[$i][0]}' value='{$frow['code']}'";
							if ($idrow[$fnames[$i][0]] == $frow['code']) {echo " checked";}
							echo " />".$frow['title']."&nbsp;\n";
							}
						echo "\t\t</font></td>\n"
							."\t</tr>\n";
						$i++;
						}
					$i--;
					echo "</table>\n";
					break;
				default: //This really only applies to tokens for non-private surveys
					echo "\t\t\t<input type='text' name='{$fnames[$i][0]}' value='"
						.$idrow[$fnames[$i][0]] . "'>\n";
					break;
				}
				echo "		</td>
						</tr>
						<tr>
							<td colspan='2' bgcolor='#CCCCCC' height='1'>
							</td>
						</tr>\n";
			}
		}
	echo "</table>\n"
		."<table width='99%' align='center' style='border: 1px solid #555555' cellpadding='1' cellspacing='0'>\n";
	if ($action == "edit")
		{
		echo "	<tr>
			 		<td bgcolor='#CCCCCC' align='center'>
					 <input type='submit' $btstyle value='"._DE_UPDATE."'>
					 <input type='hidden' name='id' value='$id'>
					 <input type='hidden' name='sid' value='$surveyid'>
					 <input type='hidden' name='action' value='update'>
					 <input type='hidden' name='surveytable' value='{$dbprefix}survey_$surveyid'>
					</td>
				</tr>\n";
		}
	elseif ($action == "editsaved")
		{
		echo "<script type='text/javascript'>
			  
			  </script>\n";
		echo "\t<tr>\n";
		echo "\t\t<td colspan='3' align='center' bgcolor='#CCCCCC'>$setfont\n";
	    echo "\t\t\t<input type='checkbox' name='save' id='save' onChange='saveshow(this.id)' onLoad='saveshow(this.id)'><label for='save'>"._DE_SAVEENTRY."</label>\n";
		echo "<div name='saveoptions' id='saveoptions' style='display: none'>\n";
		echo "<table align='center' class='outlinetable' cellspacing='0'>
			  <tr><td align='right'>"._DE_SAVEID."</td>
			  <td><input type='text' name='save_identifier'";
		if (returnglobal('identifier')) 
			{
		    echo " value=\"".stripslashes(stripslashes(returnglobal('identifier')))."\"";
			}
		echo "></td></tr>
			  </table>\n"
			."<input type='hidden' name='save_password' value='".returnglobal('accesscode')."'>\n"
			."<input type='hidden' name='save_confirmpassword' value='".returnglobal('accesscode')."'>\n"
			."<input type='hidden' name='save_email' value='".$saver['email']."'>\n"
			."<input type='hidden' name='save_scid' value='".$saver['scid']."'>\n"
			."<input type='hidden' name='redo' value='yes'>\n";
		echo "\t\t</td>\n";
		echo "\t</tr>"
			."</div>\n";
		echo "	<tr>
				<td bgcolor='#CCCCCC' align='center'>
				 <input type='submit' $btstyle value='"._SUBMIT."'>
				 <input type='hidden' name='sid' value='$surveyid'>
				 <input type='hidden' name='action' value='insert'>
				 <input type='hidden' name='surveytable' value='{$dbprefix}survey_$surveyid'>
				</td>
			</tr>\n";
		}
	
	echo  "</table>\n"
     	 ."</form>\n";
	}

elseif ($action == "update")
	{
	echo "<table width='350' align='center' style='border: 1px solid #555555' cellpadding='1' cellspacing='0'>\n"
		."\t<tr bgcolor='#555555'><td colspan='2' height='4'><font size='1' face='verdana' color='white'><strong>"
		._DATAENTRY."</strong></font></td></tr>\n"
		."\t<tr><td align='center'>\n";
	$iquery = "SELECT * FROM {$dbprefix}questions, {$dbprefix}groups WHERE {$dbprefix}questions.gid={$dbprefix}groups.gid AND {$dbprefix}questions.sid=$surveyid ORDER BY group_name, title";
	$iresult = mysql_query($iquery);
	
	$updateqr = "UPDATE $surveytable SET \n";
	
	while ($irow = mysql_fetch_array($iresult))
		{
		if ($irow['type'] != "Q" && $irow['type'] != "M" && $irow['type'] != "P" && $irow['type'] != "A" && $irow['type'] != "B" && $irow['type'] != "C" && $irow['type'] != "E" && $irow['type'] != "F" && $irow['type'] != "H" && $irow['type'] != "O" && $irow['type'] != "R" && $irow['type'] != "^")
			{
			$fieldname = "{$irow['sid']}X{$irow['gid']}X{$irow['qid']}";
			if (isset($_POST[$fieldname])) { $thisvalue=$_POST[$fieldname]; } else {$thisvalue="";}
			if (get_magic_quotes_gpc())
				//{$updateqr .= "$fieldname = '" . $_POST[$fieldname] . "', \n";}
				{$updateqr .= "`$fieldname` = '" . $thisvalue . "', \n";}
			else
				{
				if (_PHPVERSION >= "4.3.0")
					{
					$updateqr .= "`$fieldname` = '" . mysql_real_escape_string($thisvalue) . "', \n";
					}
				else
					{
					$updateqr .= "`$fieldname` = '" . mysql_escape_string($thisvalue) . "', \n";
					}
				}
			unset($thisvalue);
			// handle ! other
			if ($irow['type'] == "!" && $irow['other'] == "Y")
				{
				$fieldname = "{$irow['sid']}X{$irow['gid']}X{$irow['qid']}other";
				if (isset($_POST[$fieldname])) {$thisvalue=$_POST[$fieldname];} else {$thisvalue="";}
				if (get_magic_quotes_gpc())
					{$updateqr .= "`$fieldname` = '" . $thisvalue . "', \n";}
				else
					{
					if (_PHPVERSION >= "4.3.0")
						{
						$updateqr .= "`$fieldname` = '" . mysql_real_escape_string($thisvalue) . "', \n";
						}
					else
						{
						$updateqr .= "`$fieldname` = '" . mysql_escape_string($thisvalue) . "', \n";
						}
					}
				unset($thisvalue);
				}
			}
		elseif ($irow['type'] == "O")
			{
			$fieldname = "{$irow['sid']}X{$irow['gid']}X{$irow['qid']}";
			$updateqr .= "`$fieldname` = '" . $_POST[$fieldname] . "', \n";
			$fieldname = "{$irow['sid']}X{$irow['gid']}X{$irow['qid']}comment";
			if (get_magic_quotes_gpc())
				{$updateqr .= "`$fieldname` = '" . $_POST[$fieldname] . "', \n";}
			else
				{
				if (_PHPVERSION >= "4.3.0")
					{
					$updateqr .= "`$fieldname` = '" . mysql_real_escape_string($_POST[$fieldname]) . "', \n";
					}
				else
					{
					$updateqr .= "`$fieldname` = '" . mysql_escape_string($_POST[$fieldname]) . "', \n";
					}
				}
			}
		elseif ($irow['type'] == "R")
			{
			$i2query = "SELECT {$dbprefix}answers.*, {$dbprefix}questions.other FROM {$dbprefix}answers, {$dbprefix}questions WHERE {$dbprefix}answers.qid={$dbprefix}questions.qid AND {$dbprefix}questions.qid={$irow['qid']} AND {$dbprefix}questions.sid=$surveyid ORDER BY {$dbprefix}answers.sortorder, {$dbprefix}answers.answer";
			$i2result = mysql_query($i2query);
			$i2count = mysql_num_rows($i2result);
			for ($x=1; $x<=$i2count; $x++)
				{
				$fieldname = "{$irow['sid']}X{$irow['gid']}X{$irow['qid']}$x";
				if (get_magic_quotes_gpc())
					{$updateqr .= "`$fieldname` = '" . $_POST["d$fieldname"] . "', \n";}
				else
					{
					if (_PHPVERSION >= "4.3.0")
						{
						$updateqr .= "`$fieldname` = '" . mysql_real_escape_string($_POST["d$fieldname"]) . "', \n";
						}
					else
						{
						$updateqr .= "`$fieldname` = '" . mysql_escape_string($_POST["d$fieldname"]) . "', \n";
						}
					}
				}
			}
		else
			{
			$i2query = "SELECT {$dbprefix}answers.*, {$dbprefix}questions.other FROM {$dbprefix}answers, {$dbprefix}questions WHERE {$dbprefix}answers.qid={$dbprefix}questions.qid AND {$dbprefix}questions.qid={$irow['qid']} AND {$dbprefix}questions.sid=$surveyid ORDER BY {$dbprefix}answers.sortorder, {$dbprefix}answers.answer";
			$i2result = mysql_query($i2query);
			$otherexists = "";
			while ($i2row = mysql_fetch_array($i2result))
				{
				$fieldname = "{$irow['sid']}X{$irow['gid']}X{$irow['qid']}{$i2row['code']}";
				if (isset($_POST[$fieldname])) {$thisvalue=$_POST[$fieldname];} else {$thisvalue="";}
				$updateqr .= "`$fieldname` = '" . $thisvalue . "', \n";
				if ($i2row['other'] == "Y") {$otherexists = "Y";}
				if ($irow['type'] == "P")
					{
					$fieldname = "{$irow['sid']}X{$irow['gid']}X{$irow['qid']}{$i2row['code']}comment";
					if (get_magic_quotes_gpc())
						{$updateqr .= "`$fieldname` = '" . $_POST[$fieldname] . "', \n";}
					else
						{
						if (_PHPVERSION >= "4.3.0")
							{
							$updateqr .= "`$fieldname` = '" . mysql_real_escape_string($_POST[$fieldname]) . "', \n";
							}
						else
							{
							$updateqr .= "`$fieldname` = '" . mysql_escape_string($_POST[$fieldname]) . "', \n";
							}
						}
					}
				unset($thisvalue);
				}
			if ($otherexists == "Y") 
				{
				$fieldname = "{$irow['sid']}X{$irow['gid']}X{$irow['qid']}other";
				if (isset($_POST[$fieldname])) {$thisvalue=$_POST[$fieldname];} else {$thisvalue="";}
				if (get_magic_quotes_gpc())
					{$updateqr .= "`$fieldname` = '" . $thisvalue . "', \n";}
				else
					{
					if (_PHPVERSION >= "4.3.0")
						{
						$updateqr .= "`$fieldname` = '" . mysql_real_escape_string($thisvalue) . "', \n";
						}
					else
						{
						$updateqr .= "`$fieldname` = '" . mysql_escape_string($thisvalue) . "', \n";
						}
					}
				unset($thisvalue);
				}
			}	
		}
	$updateqr = substr($updateqr, 0, -3);
	if (isset($_POST['datestampe']) && $_POST['datestamp']) {$updateqr .= ", datestamp='{$_POST['datestamp']}'";}
	if (isset($_POST['ipaddr']) && $_POST['ipaddr']) {$updateqr .= ", ipaddr='{$_POST['ipaddr']}'";}
	if (isset($_POST['token']) && $_POST['token']) {$updateqr .= ", token='{$_POST['token']}'";}
	$updateqr .= " WHERE id=$id";
	$updateres = mysql_query($updateqr) or die("Update failed:<br />\n" . mysql_error() . "\n<pre style='text-align: left'>$updateqr</pre>");
	$thissurvey=getSurveyInfo($surveyid);
	if (isset($thissurvey['autoredirect']) && $thissurvey['autoredirect']=='Y' && $thissurvey['url']) {
	    session_write_close();
	    $url=$thissurvey['url'];
	    header("Location: $url");
	}
	while (ob_get_level() > 0) {
   		ob_end_flush();
	}
	echo "<font color='green'><strong>"._SUCCESS."</strong></font><br />\n"
		._DE_UPDATED."<br /><br />\n"
		."<a href='browse.php?sid=$surveyid&action=id&id=$id'>"._DE_VIEWTHISONE."</a>\n<br />\n"
		."<a href='browse.php?sid=$surveyid&action=all'>"._DE_BROWSE."</a><br />\n"
		."</td></tr></table>\n"
		."</body>\n";
	}

elseif ($action == "delete")
	{
	$thissurvey=getSurveyInfo($surveyid);
	echo "<table width='350' align='center' style='border: 1px solid #555555' cellpadding='1' cellspacing='0'>\n"
		."\t<tr bgcolor='#555555'><td colspan='2' height='4'><font size='1' face='verdana' color='white'><strong>"
		._DATAENTRY."</strong></font></td></tr>\n"
		."\t<tr  bgcolor='#CCCCCC'><td align='center'>$setfont\n"
		."\t\t\t<strong>".$thissurvey['name']."</strong><br />\n"
		."\t\t\t".$thissurvey['description']."\n"
		."\t\t</font></td>\n"
		."\t</tr>\n";
	$delquery = "DELETE FROM $surveytable WHERE id=$id";
	echo "\t<tr>\n";
	$delresult = mysql_query($delquery) or die ("Couldn't delete record $id<br />\n".mysql_error());
	echo "\t\t<td align='center'><br />$setfont<strong>"._DE_DELRECORD." (ID: $id)</strong><br /><br />\n"
		."\t\t\t<a href='browse.php?sid=$surveyid&action=all'>"._DE_BROWSE."</a></font>\n"
		."\t\t</td>\n"
		."\t</tr>\n"
		."</table>\n"
		."</body>\n";
	}
	
else
	{
	//This is the default, presenting a blank dataentry form
	$fieldmap=createFieldMap($surveyid);
	// PRESENT SURVEY DATAENTRY SCREEN
	echo "<table width='99%' align='center' style='margin: 3px 6px; border: 1px solid #555555' cellpadding='1' cellspacing='0'>\n"
		."\t<tr bgcolor='#555555'><td colspan='2' height='4'><font size='1' face='verdana' color='white'><strong>"
		._BROWSERESPONSES."</strong></font></td></tr>\n"
		.$surveyoptions
		."</table>";
		
	loadPublicLangFile($surveyid);
	$thissurvey=getSurveyInfo($surveyid);
	$surveytable = "{$dbprefix}survey_$surveyid";

echo "<form action='dataentry.php' name='addsurvey' method='post' id='addsurvey'>\n"
		."<table width='99%' align='center' style='border: 1px solid #555555' cellpadding='1' cellspacing='0'>\n"
		."\t<tr bgcolor='#555555'><td colspan='3' height='4'><font size='1' face='verdana' color='white'><strong>"
		._DATAENTRY."</strong></font></td></tr>\n"
		."\t<tr bgcolor='#777777'>\n"
		."\t\t<td colspan='3' align='center'><font color='white'>\n"
		."\t\t\t<strong>".$thissurvey['name']."</strong>\n"
		."\t\t\t<br>$setfont".$thissurvey['description']."</font></font>\n"
		."\t\t</td>\n"
		."\t</tr>\n";
	
	if ($thissurvey['private'] == "N") //Give entry field for token id
		{
		echo "\t<tr>\n"
			."\t\t<td valign='top' width='1%'></td>\n"
			."\t\t<td valign='top' align='right' width='30%'>$setfont<strong>"._TOKEN.":</strong></font></td>\n"
			."\t\t<td valign='top' style='padding-left: 20px'>\n"
			."\t\t\t<input type='text' name='token'>\n"
			."\t\t</td>\n"
			."\t</tr>\n";
		}
	if ($thissurvey['datestamp'] == "Y") //Give datestampentry field
		{
		echo "\t<tr>\n"
			."\t\t<td valign='top' width='1%'></td>\n"
			."\t\t<td valign='top' align='right' width='30%'>$setfont<strong>"
			._DATESTAMP.":</strong></font></td>\n"
			."\t\t<td valign='top' style='padding-left: 20px'>\n"
			."\t\t\t<input type='text' name='datestamp' value='$localtimedate'>\n"
			."\t\t</td>\n"
			."\t</tr>\n";
		}
	if ($thissurvey['ipaddr'] == "Y") //Give ipaddress field
		{
		echo "\t<tr>\n"
			."\t\t<td valign='top' width='1%'></td>\n"
			."\t\t<td valign='top' align='right' width='30%'>$setfont<strong>"
			._IPADDRESS.":</strong></font></td>\n"
			."\t\t<td valign='top' style='padding-left: 20px'>\n"
			."\t\t\t<input type='text' name='ipaddr' value='NULL'>\n"
			."\t\t</td>\n"
			."\t</tr>\n";
		}

// SURVEY NAME AND DESCRIPTION TO GO HERE
	$degquery = "SELECT * FROM {$dbprefix}groups WHERE sid=$surveyid ORDER BY group_name";
	$degresult = mysql_query($degquery);
	// GROUP NAME
	while ($degrow = mysql_fetch_array($degresult))
		{
		$deqquery = "SELECT * FROM {$dbprefix}questions WHERE sid=$surveyid AND gid={$degrow['gid']}";
		$deqresult = mysql_query($deqquery);
		echo "\t<tr>\n"
			."\t\t<td colspan='3' align='center' bgcolor='#AAAAAA'>$setfont<strong>{$degrow['group_name']}</strong></font></td>\n"
			."\t</tr>\n";
		$gid = $degrow['gid'];
		
		//Alternate bgcolor for different groups
		$bgc="";
		if ($bgc == "#EEEEEE") {$bgc = "#DDDDDD";}
		else {$bgc = "#EEEEEE";}
		if (!$bgc) {$bgc = "#EEEEEE";}
		
		$deqrows = array(); //Create an empty array in case mysql_fetch_array does not return any rows
		while ($deqrow = mysql_fetch_array($deqresult)) {$deqrows[] = $deqrow;} //Get table output into array
		
		// Perform a case insensitive natural sort on group name then question title of a multidimensional array
		usort($deqrows, 'CompareGroupThenTitle');
		
		foreach ($deqrows as $deqrow)
			{
			//GET ANY CONDITIONS THAT APPLY TO THIS QUESTION
			$explanation = ""; //reset conditions explanation
			$x=0;
			$distinctquery="SELECT DISTINCT cqid, {$dbprefix}questions.title FROM {$dbprefix}conditions, {$dbprefix}questions WHERE {$dbprefix}conditions.cqid={$dbprefix}questions.qid AND {$dbprefix}conditions.qid={$deqrow['qid']} ORDER BY cqid";
			$distinctresult=mysql_query($distinctquery);
			while ($distinctrow=mysql_fetch_array($distinctresult))
				{
				if ($x > 0) {$explanation .= " <i>"._DE_AND."</i><br />";}
				$conquery="SELECT cid, cqid, cfieldname, {$dbprefix}questions.title, {$dbprefix}questions.lid, {$dbprefix}questions.question, value, {$dbprefix}questions.type FROM {$dbprefix}conditions, {$dbprefix}questions WHERE {$dbprefix}conditions.cqid={$dbprefix}questions.qid AND {$dbprefix}conditions.cqid={$distinctrow['cqid']} AND {$dbprefix}conditions.qid={$deqrow['qid']}";
				$conresult=mysql_query($conquery);
				while ($conrow=mysql_fetch_array($conresult))
					{
					switch($conrow['type'])
						{
						case "Y": 
							switch ($conrow['value'])
								{
								case "Y": $conditions[]=_YES; break;
								case "N": $conditions[]=_NO; break;
								}
							break;
						case "G":
							switch($conrow['value'])
								{
								case "M": $conditions[]=_MALE; break;
								case "F": $conditions[]=_FEMALE; break;
								} // switch
							break;
						case "A":
						case "B":
							$conditions[]=$conrow['value'];
							break;
						case "C":
							switch($conrow['value'])
								{
								case "Y": $conditions[]=_YES; break;
								case "U": $conditions[]=_UNCERTAIN; break;
								case "N": $conditions[]=_NO; break;
								} // switch
							break;
						case "E":
							switch($conrow['value'])
								{
								case "I": $conditions[]=_INCREASE; break;
								case "D": $conditions[]=_DECREASE; break;
								case "S": $conditions[]=_SAME; break;
								}
						case "F":
						case "H":
							$value=substr($conrow['cfieldname'], strpos($conrow['cfieldname'], "X".$conrow['cqid'])+strlen("X".$conrow['cqid']), strlen($conrow['cfieldname']));
							$fquery = "SELECT * FROM {$dbprefix}labels\n"
									. "WHERE lid='{$conrow['lid']}'\n"
									. "AND code='{$conrow['value']}'";
							$fresult=mysql_query($fquery) or die("$fquery<br />".mysql_error());
							while($frow=mysql_fetch_array($fresult))
								{
								$postans=$frow['title'];
								$conditions[]=$frow['title'];
								} // while
							break;
						} // switch
					$answer_section="";
					switch($conrow['type'])
						{
						case "A":
						case "B":
						case "C":
						case "E":
						case "F":
						case "H":
							$thiscquestion=arraySearchByKey($conrow['cfieldname'], $fieldmap, "fieldname");
							$ansquery="SELECT answer FROM {$dbprefix}answers WHERE qid='{$conrow['cqid']}' AND code='{$thiscquestion[0]['aid']}'";
							$ansresult=mysql_query($ansquery);
							$i=0;
							while ($ansrow=mysql_fetch_array($ansresult))
								{
								if (isset($conditions) && count($conditions) > 0)
									{
									$conditions[sizeof($conditions)-1]="(".$ansrow['answer'].") : ".end($conditions); 
									}
								}
							$operator=_DE_AND;	// this is a dirty, DIRTY fix but it works since only array questions seem to be ORd
							break;
						default:
							$ansquery="SELECT answer FROM {$dbprefix}answers WHERE qid='{$conrow['cqid']}' AND code='{$conrow['value']}'";
							$ansresult=mysql_query($ansquery);
							while ($ansrow=mysql_fetch_array($ansresult))
								{
								$conditions[]=$ansrow['answer'];
								}
							$operator=_DE_OR;	
							break;
						}
					}
				if (isset($conditions) && count($conditions) > 1)
					{
					$conanswers = "'".implode("' ".$operator." '", $conditions)."'";
					$explanation .= " -" . str_replace("{ANSWER}", $conanswers, _DE_CONDITIONHELP2);
					}
				else
					{
					$explanation .= " -" . str_replace("{ANSWER}", "'{$conditions[0]}'", _DE_CONDITIONHELP2);
					}
				unset($conditions);
				$explanation = str_replace("{QUESTION}", "'{$distinctrow['title']}$answer_section'", $explanation);
				$x++;
				}

if ($explanation) 
				{
				$explanation = "<font color='maroon' size='1'>["._DE_CONDITIONHELP1."]<br />$explanation\n";
				echo "<tr bgcolor='$bgc'><td colspan='3'>$setfont$explanation</font></td></tr>\n";
				}

//END OF GETTING CONDITIONS

$qid = $deqrow['qid'];
			$fieldname = "$surveyid"."X"."$gid"."X"."$qid";
			echo "\t<tr bgcolor='$bgc'>\n"
				."\t\t<td valign='top' width='1%'>$setfont<font size='1'>{$deqrow['title']}</font></font></td>\n"
				."\t\t<td valign='top' align='right' width='30%'>";
			if ($deqrow['mandatory']=="Y") //question is mandatory
				{
				echo "$setfont<font color='red'>*</font></font>";
				}
			echo "<strong>{$deqrow['question']}</strong></td>\n"
				."\t\t<td valign='top' style='padding-left: 20px'>\n";
			//DIFFERENT TYPES OF DATA FIELD HERE
			if ($deqrow['help'])
				{
				$hh = addcslashes($deqrow['help'], "\0..\37'\""); //Escape ASCII decimal 0-32 plus single and double quotes to make JavaScript happy.
				$hh = htmlspecialchars($hh, ENT_QUOTES); //Change & " ' < > to HTML entities to make HTML happy.
				echo "\t\t\t<img src='$imagefiles/help.gif' alt='"._DE_QUESTIONHELP."' align='right' onClick=\"javascript:alert('Question {$deqrow['title']} Help: $hh')\" />\n";
				}
			switch($deqrow['type'])
				{
				case "5": //5 POINT CHOICE radio-buttons
					echo "\t\t\t<select name='$fieldname'>\n"
						."\t\t\t\t<option value=''>"._NOANSWER."</option>\n";
					for ($x=1; $x<=5; $x++)
						{
						echo "\t\t\t\t<option value='$x'>$x</option>\n";
						}
					echo "\t\t\t</select>\n";
					break;
				case "D": //DATE
					echo "\t\t\t<input type='text' name='$fieldname' size='10' />\n";
					break;
				case "G": //GENDER drop-down list
					echo "\t\t\t<select name='$fieldname'>\n"
						."\t\t\t\t<option selected value=''>"._PLEASECHOOSE."..</option>\n"
						."\t\t\t\t<option value='F'>"._FEMALE."</option>\n"
						."\t\t\t\t<option value='M'>"._MALE."</option>\n"
						."\t\t\t</select>\n";
					break;
				case "Q": //MULTIPLE SHORT TEXT
				case "^": //Slider
					$deaquery = "SELECT * FROM {$dbprefix}answers WHERE qid={$deqrow['qid']} ORDER BY sortorder, answer";
					$dearesult = mysql_query($deaquery);
					echo "\t\t\t<table>\n";
					while ($dearow = mysql_fetch_array($dearesult))
						{
						echo "\t\t\t\t<tr><td align='right'>$setfont"
							.$dearow['answer']
							."</font></td>\n"
							."\t\t\t\t\t<td><input type='text' name='$fieldname{$dearow['code']}'></td>\n"
							."\t\t\t\t</tr>\n";
						}
					echo "\t\t\t</table>\n";
					break;
				case "W": //Flexible List drop-down/radio-button
				case "Z":
					$deaquery = "SELECT * FROM {$dbprefix}labels WHERE lid={$deqrow['lid']} ORDER BY sortorder, code";
					$dearesult = mysql_query($deaquery);
					echo "\t\t\t<select name='$fieldname'>\n";
					while ($dearow = mysql_fetch_array($dearesult))
						{
						echo "\t\t\t\t<option value='{$dearow['code']}'";
						echo ">{$dearow['title']}</option>\n";
						}
					echo "\t\t\t\t<option selected value=''>"._PLEASECHOOSE."..</option>\n";

$oquery="SELECT other FROM {$dbprefix}questions WHERE qid={$deqrow['qid']}";
					$oresult=mysql_query($oquery) or die("Couldn't get other for list question<br />".$oquery."<br />".mysql_error());
					while($orow = mysql_fetch_array($oresult))
						{
						$fother=$orow['other'];
						}
					if ($fother == "Y") 
						{
					    echo "<option value='-oth-'>"._OTHER."</option>\n";
						}
					echo "\t\t\t</select>\n";
					if ($fother == "Y")
						{
						echo "\t\t\t$setfont"
							._OTHER.":</font>"
							."<input type='text' name='{$fieldname}other' value='' />\n";
						}
					break;
				case "O": //LIST WITH COMMENT drop-down/radio-button list + textarea
					$defexists="";				
					$deaquery = "SELECT * FROM {$dbprefix}answers WHERE qid={$deqrow['qid']} ORDER BY sortorder, answer";
					$dearesult = mysql_query($deaquery);
					echo "\t\t\t<select name='$fieldname'>\n";
					while ($dearow = mysql_fetch_array($dearesult))
						{
						echo "\t\t\t\t<option value='{$dearow['code']}'";
						if ($dearow['default_value'] == "Y") {echo " selected"; $defexists = "Y";}
						echo ">{$dearow['answer']}</option>\n";
						}
					if (!$defexists) {echo "\t\t\t\t<option selected value=''>"._PLEASECHOOSE."..</option>\n";}
					echo "\t\t\t</select>\n"
						."\t\t\t<br />"._COMMENT.":<br />\n"
						."\t\t\t<textarea cols='40' rows='5' name='$fieldname"
						."comment'></textarea>\n";
					break;
				case "R": //RANKING TYPE QUESTION
					$thisqid=$deqrow['qid'];
					$ansquery = "SELECT * FROM {$dbprefix}answers WHERE qid=$thisqid ORDER BY sortorder, answer";
					$ansresult = mysql_query($ansquery);
					$anscount = mysql_num_rows($ansresult);
					echo "\t\t\t<script type='text/javascript'>\n"
						."\t\t\t\n"
						."\t\t\t</script>\n";
					while ($ansrow = mysql_fetch_array($ansresult))
						{
						$answers[] = array($ansrow['code'], $ansrow['answer']);
						}
					for ($i=1; $i<=$anscount; $i++)
						{
						if (isset($fname))
							{
						    $myfname=$fname.$i;
							}
						if (isset($myfname) && $_SESSION[$myfname])
							{
							$existing++;
							}
						}
					for ($i=1; $i<=$anscount; $i++)
						{
						if (isset($fname))
							{
							$myfname = $fname.$i;
							}
						if (isset($myfname) && $_SESSION[$myfname])
							{
							foreach ($answers as $ans)
								{
								if ($ans[0] == $_SESSION[$myfname])
									{
									$thiscode=$ans[0];
									$thistext=$ans[1];
									}
								}
							}
						if (!isset($ranklist)) {$ranklist="";}
						$ranklist .= "\t\t\t\t\t\t&nbsp;<font color='#000080'>$i:&nbsp;<input type='text' style='width:150; color: #222222; font-size: 10; background-color: silver' name='RANK$i' id='RANK_$thisqid$i'";
						if (isset($myfname) && $_SESSION[$myfname])
							{
							$ranklist .= " value='";
							$ranklist .= $thistext;
							$ranklist .= "'";
							}
						$ranklist .= " onFocus=\"this.blur()\">\n";
						$ranklist .= "\t\t\t\t\t\t<input type='hidden' id='d$fieldname$i' name='d$fieldname$i' value='";
						$chosen[]=""; //create array
						if (isset($myfname) && $_SESSION[$myfname]) 
							{
							$ranklist .= $thiscode;
							$chosen[]=array($thiscode, $thistext);
							}
						$ranklist .= "'></font>\n";
						$ranklist .= "\t\t\t\t\t\t<img src='$imagefiles/cut.gif' alt='"._REMOVEITEM."' title='"._REMOVEITEM."' ";
						if (!isset($existing) || $i != $existing)
							{
							$ranklist .= "style='display:none'";
							}
						$mfn=$fieldname.$i;
						$ranklist .= " id='cut_$thisqid$i' onClick=\"deletethis_$thisqid(document.addsurvey.RANK_$thisqid$i.value, document.addsurvey.d$fieldname$i.value, document.addsurvey.RANK_$thisqid$i.id, this.id)\"><br />\n\n";
						}
					if (!isset($choicelist)) {$choicelist="";}
					$choicelist .= "\t\t\t\t\t\t<select size='$anscount' name='CHOICES' id='CHOICES_$thisqid' onClick=\"rankthis_$thisqid(this.options[this.selectedIndex].value, this.options[this.selectedIndex].text)\" style='background-color: #EEEFFF; font-family: verdana; font-size: 12; color: #000080; width: 150'>\n";
					foreach ($answers as $ans)
						{
						if (_PHPVERSION < "4.2.0")
							{
							if (!array_in_array($ans, $chosen))
								{
								$choicelist .= "\t\t\t\t\t\t\t<option value='{$ans[0]}'>{$ans[1]}</option>\n";
								}
							}
						else
							{
							if (!in_array($ans, $chosen))
								{
								$choicelist .= "\t\t\t\t\t\t\t<option value='{$ans[0]}'>{$ans[1]}</option>\n";
								}
							}
						}
					$choicelist .= "\t\t\t\t\t\t</select>\n";
	
					echo "\t\t\t<table align='left' border='0' cellspacing='5'>\n"
						."\t\t\t\t<tr>\n"
						."\t\t\t\t\t<td align='left' valign='top' width='200' style='border: solid 1 #111111' bgcolor='silver'>\n"
						."\t\t\t\t\t\t$setfont<strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"
						._YOURCHOICES.":</strong></font><br />\n"
						."&nbsp;&nbsp;&nbsp;&nbsp;".$choicelist
						."\t\t\t\t\t</td>\n"
						."\t\t\t\t\t<td align='left' bgcolor='silver' width='200' style='border: solid 1 #111111'>\n"
						."\t\t\t\t\t\t$setfont<strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"
						._YOURRANKING.":</strong><br />\n"
						.$ranklist
						."\t\t\t\t\t</font></td>\n"
						."\t\t\t\t</tr>\n"
						."\t\t\t</table>\n"
						."\t\t\t<input type='hidden' name='multi' value='$anscount' />\n"
						."\t\t\t<input type='hidden' name='lastfield' value='";
					if (isset($multifields)) {echo $multifields;}
					echo "' />\n";
					$choicelist="";
					$ranklist="";
					unset($answers);
					break;
				case "M": //MULTIPLE OPTIONS checkbox (Quite tricky really!)
					$qidattributes=getQuestionAttributes($deqrow['qid']);
					if ($displaycols=arraySearchByKey("display_columns", $qidattributes, "attribute", 1))
						{
					    $dcols=$displaycols['value'];
						}
					else
						{
						$dcols=0;
						}
					$meaquery = "SELECT * FROM {$dbprefix}answers WHERE qid={$deqrow['qid']} ORDER BY sortorder, answer";
					$mearesult = mysql_query($meaquery);
					$meacount = mysql_num_rows($mearesult);
					if ($deqrow['other'] == "Y") {$meacount++;}
					if ($dcols > 0 && $meacount >= $dcols)
						{
					    $width=sprintf("%0d", 100/$dcols);
						$maxrows=ceil(100*($meacount/$dcols)/100); //Always rounds up to nearest whole number
						$divider=" </td>\n <td valign='top' width='$width%' nowrap>";
						$upto=0;
						echo "<table class='question'><tr>\n <td valign='top' width='$width%' nowrap>";
						while ($mearow = mysql_fetch_array($mearesult))
							{
							if ($upto == $maxrows) 
								{
							    echo $divider;
								$upto=0;
								}
							echo "\t\t\t$setfont<input type='checkbox' name='$fieldname{$mearow['code']}' id='answer$fieldname{$mearow['code']}' value='Y'";
							if ($mearow['default_value'] == "Y") {echo " checked";}
							echo " /><label for='$fieldname{$mearow['code']}'>{$mearow['answer']}</label></font><br />\n";
							$upto++;
							}
						if ($deqrow['other'] == "Y")
							{
							echo "\t\t\t"._OTHER." <input type='text' name='$fieldname";
							echo "other' />\n";
							}
						echo "</td></tr></table>\n";
					    //Let's break the presentation into columns.
						}
					else 
						{
						while ($mearow = mysql_fetch_array($mearesult))
							{
							echo "\t\t\t$setfont<input type='checkbox' name='$fieldname{$mearow['code']}' id='answer$fieldname{$mearow['code']}' value='Y'";
							if ($mearow['default_value'] == "Y") {echo " checked";}
							echo " /><label for='$fieldname{$mearow['code']}'>{$mearow['answer']}</label></font><br />\n";
							}
						if ($deqrow['other'] == "Y")
							{
							echo "\t\t\t"._OTHER." <input type='text' name='$fieldname";
							echo "other' />\n";
							}
						}
					break;
				case "P": //MULTIPLE OPTIONS WITH COMMENTS checkbox + text
					echo "<table border='0'>\n";
					$meaquery = "SELECT * FROM {$dbprefix}answers WHERE qid={$deqrow['qid']} ORDER BY sortorder, answer";
					$mearesult = mysql_query($meaquery);
					while ($mearow = mysql_fetch_array($mearesult))
						{
						echo "\t<tr>\n";
						echo "\t\t<td>\n";
						echo "\t\t\t$setfont<input type='checkbox' name='$fieldname{$mearow['code']}' value='Y'";
						if ($mearow['default_value'] == "Y") {echo " checked";}
						echo " />{$mearow['answer']}\n";
						echo "\t\t</font></td>\n";
						//This is the commments field:
						echo "\t\t<td>\n";
						echo "\t\t\t<input type='text' name='$fieldname{$mearow['code']}comment' size='50' />\n";
						echo "\t\t</td>\n";
						echo "\t</tr>\n";
						}
					if ($deqrow['other'] == "Y")
						{
						echo "\t<tr>\n";
						echo "\t\t<td style='padding-left: 22px'>$setfont"._OTHER.":</font></td>\n";
						echo "\t\t<td>\n";
						echo "\t\t\t<input type='text' name='$fieldname"."other' size='50'/>\n";
						echo "\t\t</td>\n";
						echo "\t</tr>\n";
						}
					echo "</table>\n";
					break;
				case "N": //NUMERICAL TEXT
					echo keycontroljs();
					echo "\t\t\t<input type='text' name='$fieldname' onKeyPress=\"return goodchars(event,'0123456789.,')\" />";
					break;
				case "S": //SHORT FREE TEXT
					echo "\t\t\t<input type='text' name='$fieldname' />\n";				
					break;
				case "T": //LONG FREE TEXT
					echo "\t\t\t<textarea cols='40' rows='5' name='$fieldname'></textarea>\n";
					break;
				case "U": //LONG FREE TEXT
					echo "\t\t\t<textarea cols='50' rows='70' name='$fieldname'></textarea>\n";
					break;
				case "Y": //YES/NO radio-buttons
					echo "\t\t\t<select name='$fieldname'>\n";
					echo "\t\t\t\t<option selected value=''>"._PLEASECHOOSE."..</option>\n";
					echo "\t\t\t\t<option value='Y'>"._YES."</option>\n";
					echo "\t\t\t\t<option value='N'>"._NO."</option>\n";
					echo "\t\t\t</select>\n";
					break;
				case "A": //ARRAY (5 POINT CHOICE) radio-buttons
					$meaquery = "SELECT * FROM {$dbprefix}answers WHERE qid={$deqrow['qid']} ORDER BY sortorder, answer";
					$mearesult = mysql_query($meaquery);
					echo "<table>\n";
					while ($mearow = mysql_fetch_array($mearesult))
						{
						echo "\t<tr>\n";
						echo "\t\t<td align='right'>$setfont{$mearow['answer']}</font></td>\n";
						echo "\t\t<td>$setfont\n";
						echo "\t\t\t<select name='$fieldname{$mearow['code']}'>\n";
						echo "\t\t\t\t<option value=''>"._PLEASECHOOSE."..</option>\n";
						for ($i=1; $i<=5; $i++)
							{
							echo "\t\t\t\t<option value='$i'>$i</option>\n";
							}
						echo "\t\t\t</select>\n";
						echo "\t\t</font></td>\n";
						echo "\t</tr>\n";
						}
					echo "</table>\n";
					break;
				case "B": //ARRAY (10 POINT CHOICE) radio-buttons
					$meaquery = "SELECT * FROM {$dbprefix}answers WHERE qid={$deqrow['qid']} ORDER BY sortorder, answer";
					$mearesult = mysql_query($meaquery);
					echo "<table>\n";
					while ($mearow = mysql_fetch_array($mearesult))
						{
						echo "\t<tr>\n";
						echo "\t\t<td align='right'>$setfont{$mearow['answer']}</font></td>\n";
						echo "\t\t<td>\n";
						echo "\t\t\t<select name='$fieldname{$mearow['code']}'>\n";
						echo "\t\t\t\t<option value=''>"._PLEASECHOOSE."..</option>\n";
						for ($i=1; $i<=10; $i++)
							{
							echo "\t\t\t\t<option value='$i'>$i</option>\n";
							}
						echo "</select>\n";
						echo "\t\t</td>\n";
						echo "\t</tr>\n";
						}
					echo "</table>\n";
					break;
				case "C": //ARRAY (YES/UNCERTAIN/NO) radio-buttons
					$meaquery = "SELECT * FROM {$dbprefix}answers WHERE qid={$deqrow['qid']} ORDER BY sortorder, answer";
					$mearesult=mysql_query($meaquery);
					echo "<table>\n";
					while ($mearow = mysql_fetch_array($mearesult))
						{
						echo "\t<tr>\n";
						echo "\t\t<td align='right'>$setfont{$mearow['answer']}</font></td>\n";
						echo "\t\t<td>\n";
						echo "\t\t\t<select name='$fieldname{$mearow['code']}'>\n";
						echo "\t\t\t\t<option value=''>"._PLEASECHOOSE."..</option>\n";
						echo "\t\t\t\t<option value='Y'>"._YES."</option>\n";
						echo "\t\t\t\t<option value='U'>"._UNCERTAIN."</option>\n";
						echo "\t\t\t\t<option value='N'>"._NO."</option>\n";
						echo "\t\t\t</select>\n";
						echo "\t\t</td>\n";
						echo "</tr>\n";
						}
					echo "</table>\n";
					break;
				case "E": //ARRAY (YES/UNCERTAIN/NO) radio-buttons
					$meaquery = "SELECT * FROM {$dbprefix}answers WHERE qid={$deqrow['qid']} ORDER BY sortorder, answer";
					$mearesult=mysql_query($meaquery) or die ("Couldn't get answers, Type \"E\"<br />$meaquery<br />".mysql_error());
					echo "<table>\n";
					while ($mearow = mysql_fetch_array($mearesult))
						{
						echo "\t<tr>\n";
						echo "\t\t<td align='right'>$setfont{$mearow['answer']}</font></td>\n";
						echo "\t\t<td>\n";
						echo "\t\t\t<select name='$fieldname{$mearow['code']}'>\n";
						echo "\t\t\t\t<option value=''>"._PLEASECHOOSE."..</option>\n";
						echo "\t\t\t\t<option value='I'>"._INCREASE."</option>\n";
						echo "\t\t\t\t<option value='S'>"._SAME."</option>\n";
						echo "\t\t\t\t<option value='D'>"._DECREASE."</option>\n";
						echo "\t\t\t</select>\n";
						echo "\t\t</td>\n";
						echo "</tr>\n";
						}
					echo "</table>\n";
					break;
				case "F": //ARRAY (Flexible Labels)
				case "H":
					$meaquery = "SELECT * FROM {$dbprefix}answers WHERE qid={$deqrow['qid']} ORDER BY sortorder, answer";
					$mearesult=mysql_query($meaquery) or die ("Couldn't get answers, Type \"E\"<br />$meaquery<br />".mysql_error());
					echo "<table>\n";
					while ($mearow = mysql_fetch_array($mearesult))
						{
						echo "\t<tr>\n";
						echo "\t\t<td align='right'>$setfont{$mearow['answer']}</font></td>\n";
						echo "\t\t<td>\n";
						echo "\t\t\t<select name='$fieldname{$mearow['code']}'>\n";
						echo "\t\t\t\t<option value=''>"._PLEASECHOOSE."..</option>\n";
						$fquery = "SELECT * FROM {$dbprefix}labels WHERE lid={$deqrow['lid']} ORDER BY sortorder, code";
						$fresult = mysql_query($fquery);
						while ($frow = mysql_fetch_array($fresult))
							{
							echo "\t\t\t\t<option value='{$frow['code']}'>".$frow['title']."</option>\n";
							}
						echo "\t\t\t</select>\n";
						echo "\t\t</td>\n";
						echo "</tr>\n";
						}
					echo "</table>\n";
					break;
				}
			//echo " [$surveyid"."X"."$gid"."X"."$qid]";
			echo "\t\t</td>\n";
			echo "\t</tr>\n";
			echo "\t<tr><td colspan='3' height='2' bgcolor='silver'></td></tr>\n";		
			}		
		}
	
	if ($thissurvey['active'] == "Y")
		{
		if ($thissurvey['allowsave'] == "Y")
			{
			//Show Save Option
			echo "<script type='text/javascript'>
				  
				  </script>\n";
			echo "\t<tr>\n";
			echo "\t\t<td colspan='3' align='center' bgcolor='#CCCCCC'>$setfont\n";
		    echo "\t\t\t<input type='checkbox' name='save' id='save' onChange='saveshow(this.id)' onLoad='saveshow(this.id)'><label for='save'>"._DE_SAVEENTRY."</label>\n";
			echo "<div name='saveoptions' id='saveoptions' style='display: none'>\n";
			echo "<table align='center' class='outlinetable' cellspacing='0'>
				  <tr><td align='right'>"._DE_SAVEID."</td>
				  <td><input type='text' name='save_identifier'></td></tr>
				  <tr><td align='right'>"._DE_SAVEPW."</td>
				  <td><input type='password' name='save_password'></td></tr>
				  <tr><td align='right'>"._DE_SAVEPWCONFIRM."</td>
				  <td><input type='password' name='save_confirmpassword'></td></tr>
				  <tr><td align='right'>"._DE_SAVEEMAIL."</td>
				  <td><input type='text' name='save_email'></td></tr>
				  </table>\n";
			echo "\t\t</font></td>\n";
			echo "\t</tr>\n";
			}
		echo "\t<tr>\n";
		echo "\t\t<td colspan='3' align='center' bgcolor='#CCCCCC'>$setfont\n";
		echo "\t\t\t<input type='submit' value='"._SUBMIT."' $btstyle/>\n";
		echo "\t\t</font></td>\n";
		echo "\t</tr>\n";
		}
	elseif ($thissurvey['active'] == "N")
		{
		echo "\t<tr>\n";
		echo "\t\t<td colspan='3' align='center' bgcolor='#CCCCCC'>$setfont\n";
		echo "\t\t\t<font color='red'><strong>"._DE_NOTACTIVE."\n";
		echo "\t\t</strong></font></font></td>\n";
		echo "\t</tr>\n";	
		}
	else
		{
		echo "</form>\n";
		echo "\t<tr>\n";
		echo "\t\t<td colspan='3' align='center' bgcolor='#CCCCCC'>$setfont\n";
		echo "\t\t\t<font color='red'><strong>"._ERROR."</strong></font><br />\n";
		echo "\t\t\t"._DE_NOEXIST."</font><br /><br />\n";
		echo "\t\t\t<input $btstyle type='submit' value='"._GO_ADMIN."' onClick=\"window.open('$scriptname', '_top')\">\n";
		echo "\t\t</td>\n";
		echo "\t</tr>\n";
		echo "</table>";
		echo getAdminFooter("$langdir/instructions.html#Editing and Deleting Responses", "Using PHPSurvey to Edit Responses");
		exit;
		}
	echo "\t<tr>\n";
	echo "\t<td>\n";
	echo "\t<input type='hidden' name='action' value='insert' />\n";
	echo "\t<input type='hidden' name='surveytable' value='$surveytable' />\n";
	echo "\t<input type='hidden' name='sid' value='$surveyid' />\n";
	echo "\t</td>\n";
	echo "\t</tr>\n";
	echo "</table>\n";
	echo "\t</form>\n";
	}
echo "&nbsp;";
echo getAdminFooter("$langdir/instructions.html#Editing and Deleting Responses", "Using PHPSurvey to Edit Responses");

function array_in_array($needle, $haystack)
	{
	foreach ($haystack as $value) 
		{
		if ($needle == $value) 
      	return true;
  		}
	return false;
	}
?>

${this.title}

Code Editor : dataentry.php