dropdown problems

[lynettes]

The value I get return from the dropdown menu is not being used by the form to retrieve the correct info from the database. What am I doing wrong?

//************************************************** ******************************************
//GETS DATA
//************************************************** ******************************************
$SQL = "SELECT DISTINCT record_num, author_last_name, author_first_name FROM $DB_TABLE ORDER BY author_last_name, author_first_name";
$RESULT = mysql_query($SQL, $CONNECTION) OR die("Query failed.");
$NUM = mysql_num_rows($RESULT);
//************************************************** ******************************************
//************************************************** ******************************************
?>

<FORM METHOD='post' ACTION='authorsearch.php'>
<SELECT NAME='authorwanted'>
<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[]' SELECTED>$LNAME, $FNAME ($RECORD)</OPTION>";
}
//************************************************** ******************************************
//************************************************** ******************************************
?>
</SELECT>
<BR><BR>
<INPUT TYPE='hidden' name='authorwanted' value='set'>
<INPUT TYPE='SUBMIT' VALUE='View the Details!'>
</FORM>

<?PHP
//************************************************** ******************************************
//RETURNS INFO REQUESTED
//************************************************** ******************************************
if(isset($_POST['authorwanted']))
{

$SQL1 = "SELECT * FROM $DB_TABLE WHERE record_num = '$_POST[$RECORD]' ";
$RESULT1 = mysql_query($SQL1, $CONNECTION) OR die("Query failed." );
$NUM1 = mysql_num_rows($RESULT1);

if ($NUM1 == 0)
{
echo "No books found";
}
elseif ($NUM1 > 0)
{
echo "$FNAME $LNAME has $NUM1 books in the collection.";
echo "<BR><BR>";
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>";
}
//************************************************** ******************************************
//************************************************** ******************************************
?>
lynettes is online now   	Edit/Delete Message Reply With Quote
lynettes
View Public Profile
Send a private message to lynettes
Find More Posts by lynettes
Add lynettes to Your Buddy List
Reply

[Jump to Top of page]

  

[tomhath]

These two lines don't look right.

In the first, what value do you expect the option to have? Looks like it will be something like '123[]'

Where did $RECORD come from? That variable was used inside the while loop.

echo "<OPTION VALUE='$RECORD[]' SELECTED>$LNAME, $FNAME ($RECORD)</OPTION>"; 
...
$SQL1 = "SELECT * FROM $DB_TABLE WHERE record_num = '$_POST[$RECORD]' ";

Try them like this (untested). But first, get rid of the hidden field, it has the same name as the SELECT.

echo "<OPTION VALUE='$RECORD' SELECTED>$LNAME, $FNAME ($RECORD)</OPTION>"; 
...
$SQL1 = "SELECT * FROM $DB_TABLE WHERE record_num = '" . $_POST["authorwanted"] . "' ";

[lynettes]

MANY THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! That fixed the problem. It works but I wold like to get the correct author name printed out. I got:

Lynne Smith has 1 books in the collection.

Certified Lotus Professional: Application Development
Call Number:
ISBN: 0-7821-2668-5 Subject:
Subheadings:

but it should be Kate McCoy.

if(isset($_POST['authorwanted']))
{
$RECORD = $_POST['authorwanted']; 
$SQL1 = "SELECT * FROM $DB_TABLE WHERE record_num = '" . $_POST["authorwanted"] . "' ";
$RESULT1 = mysql_query($SQL1, $CONNECTION) OR die("Query failed." );
$NUM1 = mysql_num_rows($RESULT1);

if ($NUM1 == 0)
{
echo "No books found";
}
elseif ($NUM1 > 0)
{

echo "$FNAME $LNAME has $NUM1 books in the collection.";
echo "<BR><BR>";
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>";
}

[tomhath]

$FNAME and $LNAME were set back up in the while loop. You need to check and only save the name if a record number was posted and the row you have in the loop matches.

echo "$FNAME $LNAME has $NUM1 books in the collection.";