View Single Post
  #6  
Old 06-25-2003, 10:18 AM
 
need300z need300z is offline
 

Member
  
Join Date: May 2003
Posts: 16
 

Default

funky, i tried your code. added the random at the end of fun in the include didn't work but now I get a

INVALID SQL: 1054 : Unknown column 'discount' in 'where clause'
SQL QUERY FAILURE: SELECT * FROM xcart_products,xcart_pricing WHERE forsale='Y' AND avail>0 AND xcart_products.productid=xcart_pricing.productid AND discount > 0 ORDER BY RAND() LIMIT 6

at the top of the header. for my site, went back to the original code and still comes up this way, any idea why?


http://www.indysuperbikes.com/xcart/customer/home.php
Reply With Quote