Sql Query

[nomadrw]

If the fields exist in that table
then you can do this
select * from abc;

abc will be your table name.
this will list all the fields within that table.
you can also do an order by which will list all the fields in order.
it migh look something like this
select * from abc order by category; (or it could be by name of the product, products_id)

Where are you going to write this SQL at.
If you have XAMMP that is were I would write it
This is only a temp SQL script
nomad

[bebijuteria]

I have this query

I think that this will give me part of what i need. But now is give me timout


SELECT `products`.`products_id`,`products`.`products_image`,`products`.`products_status `, `products_description`.`products_name`, `products_to_categories`.`categories_id`
FROM products, products_description, products_to_categories

[poolprorich]

Hello,

You can't select products from products:

SELECT products_name, products_description, products_url,  products_id,products_quantity, products_model, products_image,products_price,products_virtual, products_weight,   products_date_added, products_last_modified, products_date_available, products_status, products_tax_class_id,  manufacturers_id,        products_quantity_order_min, products_quantity_order_units,   products_priced_by_attribute,     product_is_free, p.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 FROM  products, product_description
                              WHERE products_id = ''

And you have periods in place of comas
Rich

[bebijuteria]

With your query i get:

Column 'products_id' in field list is ambiguous


And i have to ad:

products_to_categories in the FROM

like this:

FROM products, products_description, products_to_categories