Why would you have thought that would work?
Add the strict pragma and fix the problems that it points out.
use strict;
If your instructor doesn't want you to use the pragma, then simply remove its use statement before turning in the assignment. However, that would be more evidence that you have a very poor instructor that teaches very bad coding practices.
Okay, I have made it work without taking the variable from the cookie subroutine. I just did the variables inside the insert subroutine.
But I have yet another problem. This html page is showing on the same page as displaysurvey which is supposed to actually show on a different page, and select statement isn't working.
Here is the subroutine:
surveyresults
{
print qq~<html>
<head>
<Title>Survey Aswers</Title>
</head>
<body>
<table border=1>
<tr>
<th>User ID</th><th>Answers</th>
<tr>~;
$select = qq~select UserID,answer from answers~;
$dbh=DBI->connect($connectionInfo,$user,$passwd);
$sth=$dbh->prepare($select);
$sth ->execute();
$answer=1;
while (@row3=$sth->fetchrow_array())
{
$select = qq~select UserID,answer from answers~;
$dbh3=DBI->connect($connectionInfo,$user,$passwd);
$sth3=$dbh->prepare($select);
$sth3 ->execute();
}
</form>
#$dbh->disconnect();
}
