This is the idea that I would like to accomplish. Perhaps you can help me with the proper syntax to do it.
sub html_view_success {
# --------------------------------------------------------
# This page displays the results of a successful search.
# You can use the following variables when displaying your
# results:
#
# $numhits - the number of hits in this batch of results.
# $maxhits - the max number of hits displayed.
# $db_total_hits - the total number of hits.
# $db_next_hits - html for displaying the next set of results.
#
my (@hits) = @_;
my ($numhits) = ($#hits+1) / ($#db_cols+1);
my ($maxhits); $in{'mh'} ? ($maxhits = $in{'mh'}) : ($maxhits = $db_max_hits);
&html_print_headers;
print qq|
<html>
<head>
<title>$html_title: Search Results.</title>
</head>
<body bgcolor="#DDDDDD">
<blockquote><center>
<FONT FACE="MS Sans Serif, arial,helvetica" size=1 COLOR="#000000">
<b>$html_title: Search Results</b>
</font></td></tr>
<tr><td>
<p><$font>
Your search returned <b>$db_total_hits</b> matches.</font>
|;
if ($db_next_hits) {
print "<br><$font>Pages: $db_next_hits</font>";
}
print"</td></tr></table>";
#Repeat this code on change in category
$tempcategory=$rec{'category'};
print"<br>Category: $rec{'category'}"
# Record would always have to be sorted by category.
# Go through each hit and convert the array to hash and send to
# html_record for printing.
for (0 .. $numhits - 1) {
print "<center>";
&html_record (&array_to_hash($_, @hits));#html_record would only contain the 'quote' field and not reprint the category field.
if $rec{'category'} ne $tempcategory {
on change in category go back and print new category title and reset $tempcategory.}#I don't know the proper syntax to do this.
print "</center>";
}
if ($db_next_hits) {
print qq~ <TABLE BORDER=1 BGCOLOR="#DDDDDD" CELLSPACING=0 CELLPADDING=3 WIDTH=500>
<TR>
<TD WIDTH=500 BGCOLOR="#FFFFcc">
<CENTER><A HREF="http"><FONT COLOR="#000000"></A>Pages: $db_next_hits</FONT></CENTER>
</TD>
</TR>
</TABLE>~;
}
print qq|
<table border=1 bgcolor="#ffffff" cellpadding=5 cellspacing=3 width=500 valign=top>
<tr><td>|; &html_footer; print qq|</td></tr>
</table></center>
</blockquote>
</body>
</html>
|;
}
I understand how to have a field category and sort by category I guess what I am looking for on the add side of things is if a user wants to add a 'note or quote' related to say 'perseverance' and another user had already added that category they should be able to select from a list of existing categories or add a new one if applicable. Could this be done by giving them a drop down and a text field with an option button beside each one so if they do not find the category they want in the drop down they can select the text field and add one? Of course then the drop down would have to refresh itself with the added categories.
