Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2006
    Posts
    123
    Plugin Contributions
    0

    Default Help writing a custom SQL query please

    Hi,

    I need to custom-modify my ZC shop to make each category, when browsed, display all the products from all the 'child' sub-categories below it.

    I guess what I need to do is write my own SQL query, to return all the products from each sub-category under the current category... in a single data structure format that can be used by "product_listing.php".

    However I don't know much about SQL or about the ZC database format... which is where you (hopefully) come in! Many many thanks in advance as this would help me a lot...

    A

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,823
    Plugin Contributions
    9

    Default Re: Help writing a custom SQL query please

    There is a commercial help area on this site
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,608
    Plugin Contributions
    25

    Default Re: Help writing a custom SQL query please

    I very much doubt that even an experienced database administrator / developer could manage this purely in SQL. And it's absolutely not an area to get into if you are not an experienced PHP/MySQL developer.

    This will involve a "tree walk" to recursively traverse the category structure. There are some Zen Cart functions that might help, but that would require working out how they work and what results they produce, which in this complex area would be a pretty major challenge in its own right.

    I think that Kobra's right to point you towards the Commercial Help Wanted section.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  4. #4
    Join Date
    Jun 2006
    Posts
    123
    Plugin Contributions
    0

    Default Re: Help writing a custom SQL query please

    I see... didn't realize it was that complex, since the "New items" display seems to do something quite similar (though it's random and limits the number of results). Thanks anyway!

 

 

Similar Threads

  1. v154 Help with a SQL Query for Query Builder
    By lindasdd in forum Managing Customers and Orders
    Replies: 2
    Last Post: 24 Mar 2016, 01:18 PM
  2. Custom inventory query statement - Need help please
    By 0be1 in forum General Questions
    Replies: 11
    Last Post: 30 May 2008, 02:32 AM
  3. Help please: adding "options" to products (sql query)
    By sjku in forum General Questions
    Replies: 19
    Last Post: 20 Feb 2008, 01:31 PM
  4. Sessions - errors - after SQL query - please help
    By JohneeMac in forum General Questions
    Replies: 1
    Last Post: 23 Sep 2006, 02:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR