mySQL Query of all Products

[Keitex]

Hi,

I need to create a query which will give me back all the products with details of

ID
TITLE
DESCRIPTION
PRODUCTTYPE
LINK
IMAGELINK
CONDITION
AVAILABILITY
PRICE
BRAND
GTIN
MPN
SHIPPING
SHIPPINGWEIGHT

I have managed to get a few of those fields but I cannot find the rest like condition and product link. Could someone help me please?

[RodG]

Some of the fields you mention simply don't exist, and not all the others exist in the same table, which means you'll need to use foreign keys to retrieve the relational data.

Not difficult to do, but I seriously doubt that anyone here is going to do it for you.

Cheers
Rod