Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

'products_date_available'


Guest

Recommended Posts

Hello all,

 

I have been trying to consolidate three tables referring to the product lines in my shop (products/product_description and product_to_categories) into one table that I have labellled "product_lines".

 

Everthing works having just tested it, but I keep getting this error on the main page:

 

1052 - Column: 'products_date_available' in field list is ambiguous

 

select p.products_id, pd.products_name, products_date_available as date_expected from product_lines p, product_lines pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by date_expected desc limit 6

 

Could some kind sould advise me as to what bits I need to fiddle with in order to get this message to disappear. I managed to figure out everything else, but I am now kerfuddled...!

 

I just noticed column_right has disappeared!

 

I kind of remember that the column is initiated after the bit that is going wrong, so I guess if I can fix that then all will be okay...

 

Thanks for any help!

Link to comment
Share on other sites

Because, apart from the one error message, everything works fine and is much easier for me in terms of editing the products table with having just the one monitor.

 

I need it to be functional in a bespoke context, not sensible... :lol:

 

Any ideas?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...