Results 1 to 2 of 2

Custom Queries

This is a discussion on Custom Queries within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; I haven't been able to find any documentation on this, but if there is, feel free to just send me ...

      
  1. #1
    Lurker
    Join Date
    Oct 2002
    Posts
    2
    Rep Power
    0


    Default Custom Queries

    I haven't been able to find any documentation on this, but if there is, feel free to just send me a link to it.

    I would like to write a custom query that will do the following:

    I want to create a link that will decipher and list products based on it's category and manufacturer status. For example, if I had a category called 'rings' and a manufacturer called 'gold' it will list all products that are in the 'rings' category with 'gold' as it's manufacturer.

    Does that make sense?

    I'd like to build it in a fashion that I could easily reuse it throughout the site (given that I make obvious changes to various elements of the string).

    Any one have anything I could look at? Or any recommended links to check out to figure out how to do this correctly?

    Thanks!!!

  2. #2
    Anonymous
    Guest


    Default Followup to Custom Queries

    Ok.....my wheels are still turning....

    Let's say that 'gold' has a manufacturer ID of 8 and 'ring' has a category id of 23.

    And to view all the contents under the 'gold' section I would use:

    oscom/catalog/default.php?manufacturers_id=8

    And to view all the contents under the 'ring' section I would use:

    oscom/catalog/default.php?cPath=23

    Theoretically, shouldn't I be able to use:

    oscom/catalog/default.php?cPath=23&manufacturers_id=8

    ??

    Am I crazy? Am I at least on the right path? Any comments on this concept?

Similar Threads

  1. So Many Queries so little time
    By delphi1 in forum osCmax v2 Customization/Mods
    Replies: 10
    Last Post: 11-07-2005, 05:02 AM
  2. securing and storing database queries
    By fun2bnuts in forum osCmax v2 Installation issues
    Replies: 2
    Last Post: 06-26-2005, 10:09 PM
  3. How do I add my own custom form??
    By david111780 in forum osCommerce 2.2 Modification Help
    Replies: 0
    Last Post: 03-14-2005, 03:20 PM
  4. sql queries overloading my hosts, what to do?
    By Anonymous in forum osCMax v1.7 Installation
    Replies: 1
    Last Post: 08-04-2004, 12:10 AM
  5. Custom Currency
    By cdhough in forum osCommerce 2.2 Modification Help
    Replies: 2
    Last Post: 07-09-2004, 11:39 AM

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
  •