query problem

[jenniferG]

we have written hundreds of queries, but very few applications with nested queries- The below code  fails o the mysql_query($QUERY2).......statement.

The error message says an error in query2?

--------------------------------------------------------------------------------------------

$QUERY1="SELECT  * FROM SIREQUESTTABLE WHERE INDEXB=1002";

$FIND=mysql_query($QUERY1)or die ('Cannot Query  PRODUCTS Error:14');

if($ROW=mysql_fetch_array($FIND)){

include 'requestfields.php';

 

$QUERY2="SELECT * SIPRODUCTTABLE";

$INVFIND=mysql_query($QUERY2)or die ('Cannot Query  INVENTORY Error:15'. mysql_error());

exit;

IF ($INVROW=mysql_fetch_array($INVFIND)){

$INVENTORY = $INVROW['INVENTORY'];

$LEADTIME  = $INVROW['LEADTIME'];

$REQUESTS  = $INVROW['REQUESTS'];}//FIELDS FROM INVROW->SIPRODUCTTABLE

 

print "$INDEXB<BR><$CAMERAMODEL<BR><$REPFIRM<P>";

print "$INVENTORY<BR>$LEADTIME<BR>$REQUESTS";

exit;

}

--------------------------------------------------------------------------------

Jennifer

[marcus]

SELECT * FROM SIPRODUCTTABLE