Hello, I'm working w/ my first SQL database and trying to get the thing to stop looping on the display entries page but at the same time allow the form within the display entries page to keep the each new value per entry separated. What I mean is each database entry gets an update for the same column but I've been getting the cgi to save for each entry whatever I choose for the first entry when I want each to be independent. I hope that someone out there can help and let me know if you need more more code.
Thanks,
Nichole


sub admin_entries
{


if (&DatabaseInit == 0) {
# init failed
print "Database access could not be initialized.";
print "</font>\n";
print "</body></html>\n";
exit;
}

my $nlr = "SELECT name, email1, email2, choice, note FROM nichole";

#Execute SQL
if (&DoSQL($nlr) == 0) {
# SQL statement failed
my $error = &GetError;
print "SQL statement did not execute properly: $error\n";
print "</font>\n";
print "</body></html>\n";
exit;
}


print"<form method=post action=boo.cgi enctype=multipart/form-data>\n";
print"<input type=hidden name=location value=update_entries>\n";

my $counter=0;
my $friend=0;
while (((my $name, my $email1, my $email2, my $choice, my $note) = &FetchRow) && $friend<10 ) {
$friend++;
#do what ever you want to do for each row here







print '<table border="0" cellpadding="4" cellspacing="1" width="100%">';
print '<tr> <td width="6" bgcolor="#F3F3F3"><font face="Verdana" size="1">';

print "<input type=\"radio\" name=\"naction" . $counter . "\" value=\"sendit\"> email<br>";
print "<input type=\"radio\" name=\"naction" . $counter . "\" value=\"delit\"> delete<br></font></td>";

$counter++;
my $count=0;
print <<"END";

<td width="613"><font face="Verdana" size="1"><strong>Name:</strong>$name <br>
<strong>Email:</strong> $email1$email2<br>
END
print "<strong>Department:</strong> <select name=\"dept\" . $count SIZE=1><option value=\"\">departments</option>";
print "<option value=\"residential life\" . $count>residential life</option>";
print "<option value=\"Campus Dining\" . $count>Campus Dining</option></select><br>";
$count++;
print<<"GO";
<strong>Type:</strong> $choice<br>
<strong>Date:</strong> <br>
<strong>Message: </strong> $note
</font></td>
</tr>
</table>
GO

}
print "<input type=submit value=submit></form></html>\n";
&email_entries;
&FinishSQL;
&DBDisconnect;
}