Jump to content
Latest News: (loading..)

Search the Community

Showing results for tags 'orderlist'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • News and Announcements
    • News and Announcements
    • Partner Announcements
    • Ambassadors
  • Commercial Support
    • Developer Feedback
  • osCommerce Online Merchant v2.x
    • General Support
    • Installation and Configuration
    • Upgrading from Earlier Versions (v2.x to v2.x)
    • Add-Ons
    • Tips and Tricks
    • Security
  • Development
    • osCommerce Online Merchant v2.4
    • osCommerce Online Merchant Community Bootstrap Edition
    • osCommerce Online Merchant v3.x
    • Development Proposals
  • General
    • OSCOMMERCE.TV
    • Next Steps / Optimizations / Marketing
    • Live Shop Reviews
    • E-Commerce Laws
    • General Discussions
    • PHP / SQL / Web Design
  • Club osC's Announcements
  • PayPal's Announcements
  • Sage Pay's Announcements
  • Solomono - new level osCommerce templates's Announcements
  • German Community's OSCOM v2.x
  • German Community's Allgemein
  • German Community's OSCOM v3.x

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Real Name


Location


Interests


Website


Skype

Found 1 result

  1. Hello, I've trying to sort on product name with this script. But everything i try the output always is sort on order number and i want to sort on product name. Please can anyone rewrite this script so the output is sort on product name? Thanks in advanced. <?php $orders_query = tep_db_query("SELECT * from " . TABLE_ORDERS . " WHERE (orders_status = '1' OR orders_status = '2')"); while($orders_rows = tep_db_fetch_array($orders_query)) { $products_query = tep_db_query("SELECT * FROM " . TABLE_ORDERS_PRODUCTS . " WHERE orders_id = '" . $orders_rows['orders_id'] . "' ORDER BY products_name"); while($products_rows = tep_db_fetch_array($products_query)) { $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>"; } } ?> Best regards, Martin
×