Inventory Tracking in MySQL

Doh! I should also add,
I have the following code allready running on this page...
[codebox]$str = "select ItemRentalPrice,ItemThumb from items where ItemID='".$values["ItemID"]."'";

$rs = CustomQuery($str);

$data = db_fetch_array($rs);

$values ['ItemRentalPrice'] = $data['ItemRentalPrice'];

$values ['ItemThumb'] = $data['ItemThumb'];

$values["Sub_total"] = $values["Qty_order"]$values["ItemRentalPrice"]1;$_SESSION["ItemThumb"] = $data["ItemThumb"];

$_SESSION["ItemRentalPrice"] = $data["ItemRentalPrice"];

return true;

[/codebox]
Another confusion issue I have with mysql is understand the $rs values etc, can it be stacked? can you mutli-query things when u need a bunch of stuff to happen? IE... can I do a $rs = CustomQuery($str)($str1))$str2); etc?
Again thnx all for any help in this.
Noel B.

Hi,
execute each query separately:

$rs1 = CustomQuery($str1);

Jane you are the best btw <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=34841&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> very helpfull <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=34841&image=2&table=forumreplies' class='bbc_emoticon' alt=':)' />
Thnx for that info,
I came to a thought last night and wrote it down, what if I did it this way for the tracking...
Using the time/date checker code above that checks to see if the current order is = to any others. Could I not then just add to that code something like below?...
======================

Do date/time check AND THEN if current itemID = date/time check itemID's then echo "not avalible are you sure you want to continue?"
=====================
How would I go about this? I know you can compare values etc, what if I compare the values of time as the code on the first post in this thread , could I not just add another statement below to check then all those times found to see if the current value ItemID is = to any ItemID value from the time/date search? if possible can I see an excample? That would be great!
Noel B

Hi,
to check two dates use following code:

if (strtotime($values["StartDateField"])-strtotime($values["EndDateField"])<0)

Well not exactly what I wanted , but I can use that concept to check a value = the other after the date search is done. So using your excample, I can run my date/time checker <>= to current and then run the comparrison to itemID using the date idea you are giving <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=34887&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> I will give this a shot.

I sent this in email as well just encase and if responded there will follow up here for others to refer too..
Does the IF statement and the THEN statement work like this?? Can someone help me clean up the

syntex a bit? I think I have it right, just something missing I think, I might have repeat values, not

sure if some are even needed at this point. I figure someone with a bit more experiance can look at this code

and say, "yea, you need to change it like this..."
BEFORE RECORD ADDED...
[codebox]$str = "select ItemID from order_item where Order_num =".$_SESSION [$strTableName."_masterkey1"];

$rs = CustomQuery($str);

$data = db_fetch_array($rs);

$values ['ItemID] = $data['ItemID'];

$_SESSION["ItemID"] = $data["ItemID"];
if($_SESSION["ItemID"] = ItemID from order_items);

THEN

$rstt = CustomQuery("select * from order_sales where Order_num=".$_SESSION [$strTableName."_masterkey1"];$rstt = $dal->order_sales->Query("Order_num=" . $values["Order_num"],"");

while($rsh=db_fetch_array($rstt))

{

if($values["event_time_start"]>=$rsh["event_time_start"] && $values["event_time_start"]<=$rsh["event_time_end"] || $values["event_time_end"]>=$rsh["event_time_start"] && $values["event_time_end"]<=$rsh["event_time_end"] || $values["event_time_start"]<=$rsh["event_time_start"] && $values["event_time_end"]>=$rsh["event_time_end"]) {

$xt->assign("message2","<div class=message><<< Selected item is already schedualed for these dates >>></div>");

return false;

}

}return true;// return true if you like to proceed with adding new record

// return false in other case [/codebox]
Now the session is the current item selected in the pulldown box and I am using that for the check to

see if the item is being used in any other order. If it is , THEN the system checks the times to make

sure if the times are within the given current order time. If not, nothing happens, if so a message is given.

answered in your personal email.

Thank you, getting really close, sent another email, I am very close to getting it done <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=34995&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
//Fatal error: Call to undefined function CustomeQuery() in D:\vhosts\mj4u\output\include\order_items_events.php on line 201
marked in the code, is the error I am getting ,current build up has this build, it is the
http://demo.asprunner.net/chaintm_yahoo_co...r_items_add.php
once upon submit, the error occurs, I have it going with partial code, I think I am just off on wording?
[codebox]//=============== carry over values from other tables ===========//

$str = "select ItemRentalPrice,ItemThumb from items where ItemID='".$values["ItemID"]."'";

$rs = CustomQuery($str);

$data = db_fetch_array($rs);

$values ['ItemRentalPrice'] = $data['ItemRentalPrice'];

$values ['ItemThumb'] = $data['ItemThumb'];

$values["Sub_total"] = $values["Qty_order"]$values["ItemRentalPrice"]1;

$_SESSION["ItemThumb"] = $data["ItemThumb"];

$_SESSION["ItemRentalPrice"] = $data["ItemRentalPrice"];

//============== global ======================//

global $strTableName;

//============ query ItemID from order_items table to see if duplicate ItemID ==========//

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

$rs = CustomQuery($str);

if ($data = db_fetch_array($rs))

{

//============ query from order_items table for Order_num ========//

$str = "select Order_num from order_items where Order_num=".$_SESSION[$strTableName."_masterkey1"];

$rs = CustomeQuery($str); //Fatal error: Call to undefined function CustomeQuery() in D:\vhosts\mj4u\output\include\order_items_events.php on line 201

}

if ($data = db_fetch_array($rs))

{

//===========query from order_sales table for dates======//

global $dal;

$rstt = $dal->order_sales->Query("Order_num=" . $values["Order_num"],"");

$rsh=db_fetch_array($rstt);

}

if($values["event_time_start"]>=$rsh["event_time_start"] && $values["event_time_start"]<=$rsh["event_time_end"] ||

$values["event_time_end"]>=$rsh["event_time_start"] && $values["event_time_end"]<=$rsh["event_time_end"] ||

$values["event_time_start"]<=$rsh["event_time_start"] && $values["event_time_end"]>=$rsh["event_time_end"])

{

echo "duplicate item for this order";

return false;

}

else

{

return true;

}[/codebox]