inventory query
Hi Eric,
Thank you for your reply it did help me to understand that I am not doing something correctly. Here is what I get as a result of the statement:
the value of the rsInventory.inventoryid is: 1 and the value of the session variable inventoryid is: 1
So as you said it is picking up the first db record. I have worked the query seven ways to sunday. Not sure how to change the session since I want to retrieve the inventoryid from the inventory table. Here is my latest query which returns to me the statement above:
mysql_select_db($database_connMegan, $connMegan);
$query_rsInventory = "SELECT inventory.inventoryid, inventory.prodid, inventory.catid, inventory.`size`, inventory.quantity, products.prodid, products.catid, products.itemnumber, products.price FROM inventory, products WHERE inventory.prodid = products.prodid AND inventory.inventoryid = inventory.inventoryid";
$rsInventory = mysql_query($query_rsInventory, $connMegan) or die(mysql_error());
$row_rsInventory = mysql_fetch_assoc($rsInventory);
$totalRows_rsInventory = mysql_num_rows($rsInventory);
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["inventoryid"] = "".$row_rsInventory['inventoryid'] ."";
die("the value of the rsInventory.inventoryid is: " . $row_rsInventory['inventoryid'] . " and the value of the session variable inventoryid is: " . $_SESSION["inventoryid"] . "");
}
When I test the recordset, all of the product info lines up with the inventoryid info. Not sure what you mean by filtering.
Thank you