jenniferG Posted August 22, 2007 Share Posted August 22, 2007 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 Link to comment https://forums.phpfreaks.com/topic/66080-query-problem/ Share on other sites More sharing options...
marcus Posted August 22, 2007 Share Posted August 22, 2007 SELECT * FROM SIPRODUCTTABLE Link to comment https://forums.phpfreaks.com/topic/66080-query-problem/#findComment-330489 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.