| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
Random Manufacturers in Manufacturer menu box | ||||
|
|
Thread Tools | Search this Thread |
#11
|
|||||||||
|
|||||||||
Re: Random Manufacturers in Manufacturer menu box
Yes if you just find
ORDER BY <Something here> you can replace that with ORDER BY Rand() Hope that helps! Carrie
__________________
Custom Development, Custom Coding and Pre-built modules for X-cart since 2002! We support X-cart versions 3.x through 5.x! Home of the famous Authorize.net DPM & CIM Modules, Reward Points Module, Point of Sale module, Speed Booster modules and more! Over 200 X-cart Mods available & Thousands of Customizations Since 2002 - bcsengineering.com Please E-Mail us for questions/support! |
|||||||||
#12
|
|||||||
|
|||||||
Re: Random Manufacturers in Manufacturer menu box
Quote:
Hi Carrie, I assume one could list specific manufacturers in the manufacturer menu box by using the ORDER BY, but how would I call manufacturerid=21 and manufacturerid=832 specifically? Hope this isn't a huge deviation from the topic?
__________________
xCart Pro Version 4.0.17, 4.0.19, 4.1.8, 4.1.10, 4.1.11, 4.1.12 - retired xCart Pro Version 4.3.1 - production xCart Pro Version 4.5.1 - testing RHEL Platform |
|||||||
#13
|
|||||||
|
|||||||
Re: Random Manufacturers in Manufacturer menu box
onto it here -
SELECT 'manufacturer_id' FROM 'xcart_manfacturers' WHERE 'manufacturer_id' = 53 or WHERE 'manufacturer_id' = 60 or WHERE 'manufacturer_id' = 100 ORDER BY 'manufacturer_id' The syntax isn't exactly right, but this should do it. Would someone help me with the syntax of the php as the is driving me nuts?
__________________
xCart Pro Version 4.0.17, 4.0.19, 4.1.8, 4.1.10, 4.1.11, 4.1.12 - retired xCart Pro Version 4.3.1 - production xCart Pro Version 4.5.1 - testing RHEL Platform |
|||||||
#14
|
|||||||||
|
|||||||||
Re: Random Manufacturers in Manufacturer menu box
Try this
SELECT 'manufacturer_id' FROM 'xcart_manfacturers' WHERE 'manufacturer_id' = 53 or 'manufacturer_id' = 60 or 'manufacturer_id' = 100 ORDER BY 'manufacturer_id' Basically take out the extra "where"'s Carrie
__________________
Custom Development, Custom Coding and Pre-built modules for X-cart since 2002! We support X-cart versions 3.x through 5.x! Home of the famous Authorize.net DPM & CIM Modules, Reward Points Module, Point of Sale module, Speed Booster modules and more! Over 200 X-cart Mods available & Thousands of Customizations Since 2002 - bcsengineering.com Please E-Mail us for questions/support! |
|||||||||
#15
|
|||||||
|
|||||||
Re: Random Manufacturers in Manufacturer menu box
Quote:
Bingo! Did it. Cheers.
__________________
xCart Pro Version 4.0.17, 4.0.19, 4.1.8, 4.1.10, 4.1.11, 4.1.12 - retired xCart Pro Version 4.3.1 - production xCart Pro Version 4.5.1 - testing RHEL Platform |
|||||||
#16
|
|||||||||
|
|||||||||
Re: Random Manufacturers in Manufacturer menu box
Great!
Carrie
__________________
Custom Development, Custom Coding and Pre-built modules for X-cart since 2002! We support X-cart versions 3.x through 5.x! Home of the famous Authorize.net DPM & CIM Modules, Reward Points Module, Point of Sale module, Speed Booster modules and more! Over 200 X-cart Mods available & Thousands of Customizations Since 2002 - bcsengineering.com Please E-Mail us for questions/support! |
|||||||||
#17
|
|||||||||
|
|||||||||
Re: Random Manufacturers in Manufacturer menu box
Carrie you've done so much for me already ( the whole image checker module revamp you did last week) I hate to ask for any more. Is there a updated version of this for 4.4.5? The customer_manufacturers.php is a little different in this version.
__________________
X-Cart version 4.6.6 X-Cart Gold Product Configurator Feature Comparison Website Manager www.RPMOFFROAD.com |
|||||||||
#18
|
|||||||||
|
|||||||||
Re: Random Manufacturers in Manufacturer menu box
Hi! Boy you dug up an OLD thread.
For 4.4.5, look in the modules/Manufacturers/func.php and look for: Code:
Below that you will see: Code:
Code:
I haven't tried it but it should work unless I missed something obvious. Carrie
__________________
Custom Development, Custom Coding and Pre-built modules for X-cart since 2002! We support X-cart versions 3.x through 5.x! Home of the famous Authorize.net DPM & CIM Modules, Reward Points Module, Point of Sale module, Speed Booster modules and more! Over 200 X-cart Mods available & Thousands of Customizations Since 2002 - bcsengineering.com Please E-Mail us for questions/support! |
|||||||||
#19
|
|||||||||
|
|||||||||
Re: Random Manufacturers in Manufacturer menu box
Its confirmed, you are a X-Cart Goddess!! Thanks again Carrie. Its amazing what you can do with this stuff!! Any testing on anything you want to do I am your guinea pig.
__________________
X-Cart version 4.6.6 X-Cart Gold Product Configurator Feature Comparison Website Manager www.RPMOFFROAD.com |
|||||||||
#20
|
|||||||||
|
|||||||||
Re: Random Manufacturers in Manufacturer menu box
Quote:
Thanks! You're so kind! I'm glad it worked! Carrie
__________________
Custom Development, Custom Coding and Pre-built modules for X-cart since 2002! We support X-cart versions 3.x through 5.x! Home of the famous Authorize.net DPM & CIM Modules, Reward Points Module, Point of Sale module, Speed Booster modules and more! Over 200 X-cart Mods available & Thousands of Customizations Since 2002 - bcsengineering.com Please E-Mail us for questions/support! |
|||||||||
|
|||
X-Cart forums © 2001-2020
|