Sql Query

[poolprorich]

I need a query to select this fields

name of the product
products_id
price
category
image
stock
descripton

Iam sorry did not realize you needed product to categories,

anyway, Column 'products_id' in field list is ambiguous

this is a problem with MySql and i did not put 2 and 2 together u must place table prior to any duplicate fields to seperate from others.
Try this it should work for you:

SELECT products.products_id, products_type, products_quantity, products_model, products_image, products_price, products_virtual, products_date_added, products_last_modified, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_ordered, products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute, product_is_free, product_is_call, products_quantity_mixed, product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order, products_discount_type, products_discount_type_from, products_price_sorter, master_categories_id, products_mixed_discount_quantity, metatags_title_status, metatags_products_name_status, metatags_model_status, metatags_price_status, metatags_title_tagline_status, products_michel_cat_no, products_scott_cat_no, products_yvert_cat_no, products_sg_cat_no, products_type_logo, products_type_logo2, products_type_logo3, products_item_no, item_year, item_fault, cancel_country_send, cancel_country_receive, cancel_town_send, cancel_town_receive, item_type, storage_loc, cancel_date_send, logo_id,  products_description.products_id, language_id, products_name, products_description, products_url, products_viewed, products_to_categories.products_id, categories_id


FROM products, products_description, products_to_categories