This is a discussion on Order Editor within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; After seeing the patch posted by eholme I did some research into MySQL queries, specifically the use of LEFT JOIN ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| ||||
| ||||
| After seeing the patch posted by eholme I did some research into MySQL queries, specifically the use of LEFT JOIN vs. INNER JOIN, and found that the use of LEFT JOIN within Order Editor was totally unnecessary. The following changes were made for this version: -the query eholme optimized was deleted -all remaining instances of LEFT JOIN were replaced with INNER JOIN -cleaned up the code for a number of queries to make them easier to read Changed files: admin/edit_orders.php, admin/search_suggest.php, admin/includes/classes/oe_order.php More...
__________________ Michael Sasek osCMax Developer
|
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Order Editor | michael_s | New osCommerce Contributions | 0 | 04-28-2007 08:30 AM |
| Order Editor | michael_s | New osCommerce Contributions | 0 | 04-10-2007 05:11 AM |
| Order Editor | michael_s | New osCommerce Contributions | 0 | 02-01-2007 04:52 AM |
| Order Editor | michael_s | New osCommerce Contributions | 0 | 01-28-2007 05:03 PM |
| Regarding Order Editor | jikey | osCMax v2 Features Discussion | 2 | 11-23-2006 03:41 PM |