Sum in this type of query possible?

thinking on this further, could it be a simple syntax issue?

Noel,
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.

Noel,

ok I cleaned up the security issues that my company doesn't want released and gave you in email direct links and login/pass to ftp , the project is very large.
Noel

oh my bad jane,
I forgot to mention this code is in the order_items page and the menu system issue is order_sales . Sorry about that. Also I notice my text error above with $rsSelect not being $rsSelect1 but eh, it errored out prior, so I usually troubleshoot and finish the code as I go. If it is not seen what I am doing in all of that.
The times/dates are checked along with the sum total vs the total of item being order to see if the item being checked within all orders within the dates/times given is sum then ofcourse comparing that sum to the total of the item being order to make sure it doesn't exceed any orders for those given dates/times that are between or equal to the current order. Hope that makes sense, I think once you read threw the code you will see what I mean.
Please note I know I have more code to add elswhere to finish this whole process, but for some reason the sum wasn't working, it did once, then stopped and i changed nothing. So begin double guessing my own work. Looking forward to your thoughts.
Noel

I figured this out, for those that know stuff and want to know what I did see below...
//============ query ItemID from order_items table to see if duplicate ItemID ==========//

$str6 = "select ItemID from order_items where Order_num=".$_SESSION[$strTableName."_masterkey1"]." and ItemID=".$values["ItemID"];

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

if ($data6 = db_fetch_array($rs6))

{

echo "<font color=red><big><b>DUPLICATE ITEM</b></big></font> for this order, please select another item or goto list to edit current";

return false;

}

else

//============ query from order_items table for Order_num if ItemID exisist in another order then continue ========//

{

$str3 = "select ItemID from order_items where ItemID=".$values["ItemID"];

$rs3 = db_query($str3,$conn);

}

if ($data3 = db_fetch_array($rs3))

//=====================================query from event_times for dates/inventory avaliblity=============================//

{

$str3 = "select sum(Qty_Order) as total_qty from event_times where Order_ID!=".$_SESSION[$strTableName."_masterkey1"]." and Item_ID=".$values["ItemID"];

$hrs3 = db_query($str3,$conn);

$rs3 = db_fetch_array($hrs3,$conn);

$data3 = $rs3['total_qty'];
$str5 = "select sum(ItemStockPhys) as total_qty2 from items where ItemID=".$values["ItemID"];

$hrs5 = db_query($str5,$conn);

$rs5 = db_fetch_array($hrs5,$conn);

$data5 = $rs5['total_qty2'];

$data6["temp_total"] = ($values["Qty_order"]+$data3["Qty_Order"])-1;
$str1 = "select event_time_start,event_time_end from event_times where Order_ID=".$_SESSION[$strTableName."_masterkey1"];

$rsh1 = db_query($str1,$conn);

while ($data1= db_fetch_array($rsh1))
$strSelect = "select * from event_times where Order_ID!=".$_SESSION[$strTableName."_masterkey1"]."

and Item_ID=".$values["ItemID"]." and event_time_start<=".$data1["event_time_start"]." and event_time_end>=".$data1["event_time_start"]."

and ".$data6["temp_total"]." >= ".$data5["ItemStockPhys"];
$rsSelect = db_query($strSelect,$conn);
{

if ($dataSelect = db_fetch_array($rsSelect))