View Single Post
  #24  
Old 01-17-2003, 12:17 AM
 
dfaa dfaa is offline
 

Member
  
Join Date: Sep 2002
Location: Norway
Posts: 14
 

Default 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')
Reply With Quote