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.

sub admin_entries

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

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";

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 ) {
#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>";

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

<td width="613"><font face="Verdana" size="1"><strong>Name:</strong>$name <br>
<strong>Email:</strong> $email1$email2<br>
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>";
<strong>Type:</strong> $choice<br>
<strong>Date:</strong> <br>
<strong>Message: </strong> $note

print "<input type=submit value=submit></form></html>\n";