getting error at query 2 failed and ...

[lynettes]

can't populate dropdown from query and can't get results. fails at query 2?

</DIV>
<DIV ID="navigation" ALIGN="center">
<?php include("includes/main_nav.htm") ?>
</DIV>
<DIV ID="content" ALIGN="center">
<H3>Search By Author:</H3>
<?PHP
//*****************************************************************************************
//CONNECTS DATABASE
//*****************************************************************************************
$DB_SERVER = "localhost";
$DB_USER = "";
$DB_PASS = "password";
$DB_NAME = "";
$DB_TABLE = "";

$CONNECTION = mysql_connect($DB_SERVER, $DB_USER, $DB_PASS) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db($DB_NAME) or die("Couldnt select database");
//*****************************************************************************************
//*****************************************************************************************

//*****************************************************************************************
//GETS DATA AND POPULATES COMBO BOX
//****************************************************************************************
$SQL = "SELECT FROM $DB_TABLE";
$RESULT = mysql_query($SQL, $CONNECTION) OR die("Query failed 1");
$NUM = mysql_num_rows($RESULT);

for ($X = 0; $X <= $NUM; $X++)
{
$RECORD = $ROW["record_num"];
$LNAME = $ROW["author_last_name"];
$FNAME = $ROW["author_first_name"];

$INFO_BLOCK = "<OPTION VALUE='$RECORD'>$LNAME, $FNAME</OPTION>";
}
//*****************************************************************************************
//*****************************************************************************************

//*****************************************************************************************
//RETURNS INFO REQUESTED
//****************************************************************************************
if(isset($_POST['selectauthor']))
{
$SQL1 = "SELECT FROM BOOK WHERE 'author_last_name' = $LNAME";
$RESULT1 = mysql_query($SQL1, $CONNECTION) OR die("Query failed 2" );
$NUM1 = mysql_num_rows($RESULT);

$i = 0;

if ($NUM1 == 0)
{
echo "No books found!";
}
elseif ($NUM1 > 0)
{
echo "This authour has $NUM1 books available:<BR><BR>";
echo "<TABLE ALIGN='center' CELLSPACING='2' CELLPADDING='2' BORDER='1' FRAME='box'>";
while ($i < $NUM1)
{
$TITLE = $ROW["title_of_publication"];
$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'>$TITLE</TD></TR>";
echo "<TR><TD>Call Number:</TD><TD COLSPAN='3'>$CALL1<BR>$CALL2</TD></TR>";
echo "<TR><TD>ISBN:</TD><TD>$ISBN</TD><TD>Subject:</TD><TD>$SUBJECT</TD></TR>";
echo "<TR><TD>Subheadings:</TD><TD COLSPAN='3'>$SUBHEADINGS</TD></TR>";

$i = $i++;
}
echo "</TABLE>";
}
}
//*****************************************************************************************
//*****************************************************************************************
?>

<FORM METHOD='post' ACTION='authorsearch.php'>
<INPUT TYPE='text' NAME='author_last_name'>

<BR><BR>
<INPUT TYPE='hidden' name='selectauthor' value='set'>
<INPUT TYPE='SUBMIT' VALUE='View the Details!'>
<INPUT TYPE='RESET' VALUE='Clear Selection!'>
</FORM>
</DIV>
<DIV ID="footer" ALIGN="center">
<?php include("includes/main_footer.htm") ?>
</DIV>

[devinemke]

as always, use [man]mysql_error[/man] to see what the problem is. i suggest you change this:

$SQL1 = "SELECT * FROM BOOK WHERE 'author_last_name' = $LNAME";

to this:

$SQL1 = "SELECT * FROM BOOK WHERE author_last_name = '$LNAME'";