I'm making progress. Drop down works but I can't get it to match input to database and return info.
<FORM METHOD='post' ACTION='authorsearch.php'>
<SELECT NAME="wanted">
<OPTION VALUE="0" SELECTED>--- Browse Authors ---</OPTION>
<?PHP
// **************************************************
//POPULATES COMBO BOX
// **************************************************
while ($ROW = mysql_fetch_array($RESULT))
{
$RECORD = $ROW["record_num"];
$LNAME = $ROW["author_last_name"];
$FNAME = $ROW["author_first_name"];
echo "<OPTION VALUE='$RECORD'>$LNAME, $FNAME</OPTION>";
}
// **************************************************
// **************************************************
?>
</SELECT>
<BR><BR>
<INPUT TYPE='hidden' name='selectauthor' value='set'>
<INPUT TYPE='SUBMIT' VALUE='View the Details!'>
<INPUT TYPE='RESET' VALUE='Clear Selection!'>
</FORM>
<?PHP
// **************************************************
//RETURNS INFO REQUESTED
// **************************************************
if(isset($POST['selectauthor']))
{
$RECORD1 = $POST['$RECORD'];
$LNAME1 = $POST['$LNAME'];
$FNAME1 = $POST['$FNAME'];
$SQL1 = "SELECT * FROM $DB_TABLE WHERE record_num = '$RECORD1'";
$RESULT1 = mysql_query($SQL1, $CONNECTION) OR die("Query failed 2" );
$NUM1 = mysql_num_rows($RESULT);
if ($NUM1 == 0)
{
echo "No books found";
}
elseif ($NUM1 > 0)
{
echo "<TABLE ALIGN='center' CELLSPACING='2' CELLPADDING='2' BORDER='1' FRAME='box'>";
}
while ($ROW = mysql_fetch_array($RESULT1))
{
$TITLE = $ROW["title"];
$CALL1 = $ROW["call_number_1"];
$CALL2 = $ROW["call_number_2"];
$PAGES = $ROW["number_of_pages"];
$SUBJECT = $ROW["subject"];
$ISBN = $ROW["isbn"];
$SUBHEADINGS = $ROW["subheadings"];
echo "<TR><TD COLSPAN='4'><STRONG>$TITLE</STRONG></TD></TR>";
echo "<TR><TD><STRONG>Call Number:</STRONG></TD><TD COLSPAN='3'>$CALL1<BR>$CALL2</TD></TR>";
echo "<TR><TD><STRONG>ISBN:</STRONG></TD><TD>$ISBN</TD><TD><STRONG>Subject:</STRONG></TD><TD>$SUBJECT</TD></TR>";
echo "<TR><TD><STRONG>Subheadings:</STRONG></TD><TD COLSPAN='3'>$SUBHEADINGS</TD></TR>";
}
echo "</TABLE>";
}
// **************************************************
// **************************************************
?>
