| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
Random Products - 2 Products Per Row - In Place of Featured | ||||
|
|
Thread Tools | Search this Thread |
#21
|
|||||||
|
|||||||
Thanks m8
We are running on www.overclock.co.uk already but just havent implemented xcart as yet. i am running here on a complete wireless Lan, it is amazing lol no wires. we should be getting some NetGear stuff in soon aswell Jonny. |
|||||||
#22
|
|||||||
|
|||||||
Enter Your Price
Hi have installed these scripts among ther script and it all work great, but on The Enter your price,(under feature) i want to display the actual price , how can this bee done i have tried to modify the products.tpl and enter
<font class=TableCenterProductTitleOrange>{$lng.lbl_ente r_your_price} to <font class=TableCenterProductTitleOrange>{$products[product].price} but it only displays 0.00 Can someone help me out here http://data.eol.no |
|||||||
#23
|
|||||||
|
|||||||
Try this new and revised code for the randoms.php file. It now joins the product table with the pricing table - should have been in there really to start with..sorry everyone
Code:
__________________
ex x-cart guru |
|||||||
#24
|
|||||||
|
|||||||
Error after new randoms.php
Hi there must be something wrong with the new code. ir runs an SQL eror.
INVALID SQL: 1052 : Column: 'productid' in where clause is ambiguous SQL QUERY FAILURE: SELECT * FROM xcart_products,xcart_pricing WHERE forsale='Y' AND avail>0 AND xcart_products.productid=xcart_pricing.productid AND (productid='8' OR productid='47' OR productid='61' OR productid='54' OR productid='40' OR productid='34' OR productid='11' OR productid='42' OR productid='60' OR productid='57') |
|||||||
#25
|
|||||||
|
|||||||
okay - sorry..amateur mistake
amend the code to: Code:
__________________
ex x-cart guru |
|||||||
#26
|
|||||||
|
|||||||
Funky, this code is great and your instructions are GREAT! I just read through the thread, followed the steps, used the revised random.php code and it works perfect.
But of course, I have a question. Sometimes it shows 7, 8 or 9 products. I only have 50 products added so far, so I'm thinking that once I get all 300 or so added in that it will always show 10. If not, I really don't care, because just having it randomize is SO COOL! Thanks, Cameron |
|||||||
#27
|
|||||||
|
|||||||
Thanks.
It should be showing 10 products though.
__________________
ex x-cart guru |
|||||||
#28
|
|||||||
|
|||||||
No worries. I realized that I like having 8 products there, anyway, so I changed the value to 8. Sometimes it shows 6 or 7, but I think it is actually cool so that people coming back see a pretty dynamic page. Google spiders will probalby love it, too.
Cameron |
|||||||
#29
|
|||||||
|
|||||||
cant remember why I wrote this now , but very useful instead of featured products and to have a different looking front page every visit.
__________________
ex x-cart guru |
|||||||
#30
|
|||||||
|
|||||||
Funky, You wrote it because I asked if anybody had this feature, and you came in and knocked it out in no time. Mine also comes up one short on occasion, but it's no big deal at all. Thanks a MILLION for the great code!
__________________
- okdpm X-Cart Gold Version: 3.5.1 Things are more like they are now than they have ever been before... |
|||||||
|
|||
X-Cart forums © 2001-2020
|