multiple queries

After my last post I tried this in after add and got an error
global $conn;

$str2 = "select LAST_INSERT_ID() from `items`";

$rs2 = db_query($str2,$conn);

$data2 = db_fetch_numarray($rs2);

$_SESSION["last_inserted_row"] = $data2[0];
//code to get the location selected from the last inserted record

$str6 = "select location from items where uniqueid = $_SESSION["last_inserted_row"]";

$rs6 = db_query($str6,$conn);


//code to lookup the default status for the location selected above

$str3 = "select defstatus from adminstatus where location = $rs6";

$rs3 = db_query($str3,$conn);
//code to update the status of the last added record with the status obtained from the adminstatus table

$str4 = "update set status = $rs3 where uniqueid =$_SESSION["last_inserted_row"]";

$rs4 db_query($str4,$conn);
//code to display the details of the added record

header("Location: items_view.php?editid1=".$_SESSION["last_inserted_row"]);

$strSQLInsert = 'INSERT INTO `stockcontrol`.`_iteminc` (`value`, `CreatedByPHPRunner`, `dummy`) VALUES (NULL, NULL, \'bob\');';

db_exec($strSQLInsert,$conn);

return true;
I then get the error message
Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /var/www/stores/include/WasteManager_events.php on line 115
Any suggestions as to what I'm doing wrong?

Hi,
to debug your code I recommend you to use echo expression after all your queries:

global $conn;