I have a page on my site where I can optionaly filter by certain fields
(order by filesize or file category), but I am implementing a shopping cart
type of idea where users can submit an order.
As administrators, my coworkers and I need to be able to filter orders by
their contents. For example:
View all orders for "Jack and the Beanstalk," where an order may have Jack
and the Beanstalk and other items.
I have an order table that keeps track of the order_id, the date, the
status, etc. I also have an order_lineitem table that is the contents of the
order. This has a one-to-many structure (without foreign keys because it is
mysql).
I was baffled as to how to filter the orders by the item_id that appears in
the order_lineitem table.
I just came up with this, but I'm not sure how the mysql_queries will handle
an array. Do I have to do some extensive regular expression management here
to get this to work, or will it accept an array?
<?php
if (isset($_POST['showid']))
$showid = $_POST['showid'];
$subSQL = "SELECT order_id FROM afy_show_lineitem WHERE show_id =
{$_POST['showid']};";
$subResult = mysql_query($subSQL);
$where = "WHERE";
$extQuery = 'order_id = {$subResult}';
}
$resultOrders = mysql_query("SELECT * FROM afy_order {$where} {$extQuery};")
or die(mysql_error("Could not query the database!"));
?>
