Jump to content

query problem


jenniferG

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.