Exclude from query

jacktheripper · September 30, 2009

Hi

I am using the orderlist contribution but i need to get it to do 2 things one is to remove despached items from the report and also list the attibutes of the products if possible?

I have tried to use exclude to exclude the depatched...........

$orders_query = tep_db_query("SELECT * from " . TABLE_ORDERS . " ORDER by orders_status, orders_id desc");

while($orders_rows = tep_db_fetch_array($orders_query, $exclude = 'Despached')

this didnt work, fortunatly didnt make an error but still listed the despached items!

any help would be really aprechiated

regards

Jack

here is the code of the contribution,

*/

require('includes/application_top.php');

// get main currency symbol for this store

$currency_query = tep_db_query("select symbol_left from " . TABLE_CURRENCIES . " where code = '".DEFAULT_CURRENCY."' ");

$currency_symbol_results = tep_db_fetch_array($currency_query);

$store_currency_symbol = tep_db_output($currency_symbol_results['symbol_left']);

setlocale(LC_MONETARY, 'en_US');

function get_month($mo, $yr) {

$query = "SELECT * FROM " . TABLE_ORDERS. " WHERE date_purchased LIKE \"$yr-$mo%\"";

$result = mysql_query($query) or die("Query failed : " . mysql_error());

$month=0;

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {

$month++;

}

mysql_free_result($result);

return $month;

}

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

</head>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

</table></td>

<table>

<tr>

<th class=dataTableHeadingRow bgcolor=silver>Status</th>

<th class=dataTableHeadingRow bgcolor=silver>Order No.</th>

<th class=dataTableHeadingRow bgcolor=silver>Product Description</th>

<th class=dataTableHeadingRow bgcolor=silver>Price</th>

</tr>

<?php

$orders = "";

$orders_query = tep_db_query("SELECT * from " . TABLE_ORDERS . " ORDER by orders_status, orders_id desc");

while($orders_rows = tep_db_fetch_array($orders_query, $exclude = 'Despached'))

{

$products = "";

$products_query = tep_db_query("SELECT * FROM " . TABLE_ORDERS_PRODUCTS . " WHERE orders_id = '" . $orders_rows['orders_id'] . "' ");

while($products_rows = tep_db_fetch_array($products_query))

{

$ordStatus="";

$ordStatus_query = tep_db_query("SELECT * from " . TABLE_ORDERS_STATUS . " WHERE orders_status_id = '" . $orders_rows['orders_status'] . "' ");

$ordStatus_rows = tep_db_fetch_array($ordStatus_query);

echo "<tr>";

echo "<td class=dataTableContent>" . $ordStatus_rows["orders_status_name"] . "</td>";

echo "<td class=dataTableContent>" . $orders_rows["orders_id"] . "</td>";

echo "<td class=dataTableContent>" . $products_rows["products_quantity"] . "</td>";

echo "<td class=dataTableContent>" . $products_rows["products_name"] . "</td>";

echo "<td class=dataTableContent>" . $products_rows["products_price"] . "</td>";

echo "</tr>";

}

?>

</TABLE>

</td>

</tr>

</table>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

</body>

</html>

Exclude from query

Recommended Posts

jacktheripper

Join the conversation

Browse

Activity