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 ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| 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!!! |
| Sponsored Links | ||
| ||
|
#2
| |||
| |||
| 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? |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| So Many Queries so little time | delphi1 | osCMax v2 Customization/Mods | 10 | 11-07-2005 04:02 AM |
| securing and storing database queries | fun2bnuts | osCMax v2 Installation issues | 2 | 06-26-2005 09:09 PM |
| How do I add my own custom form?? | david111780 | osCommerce 2.2 Modification Help | 0 | 03-14-2005 02:20 PM |
| sql queries overloading my hosts, what to do? | Anonymous | osCMax v1.7 Installation | 1 | 08-03-2004 11:10 PM |
| Custom Currency | cdhough | osCommerce 2.2 Modification Help | 2 | 07-09-2004 10:39 AM |