Building CSV list

[Limitless]

ok, then you either need to change the select statement or connect directly to the database and run the command on the zencart db not on the default db.

[familynow]

okay. So this is what I built from your example:

SELECT wzc_products.products_id as "Product ID", wzc_products_description.products_name as "Product Name", wzc_products.products_model as "Product Model", wzc_manufacturers_info.manufacturers_id as "Manufacturers ID", wzc_manufacturers.manufacturers_name as "Manufacturers Name"

FROM products
INNER JOIN wzc_products_description ON wzc_products_description.products_id = wzc_products.products_id
INNER JOIN wzc_manufacturers_info On wzc_products.manufacturers_id = wzc_manufacturers_info.manufacturers_id 
INNER JOIN wzc_manufacturers On wzc_manufacturers_info.manufacturers_id = wzc_manufacturers.manufacturers_id

I was getting an error "#1054 - Unknown column 'wzc_products.products_id' in 'field list' " but when I removed the ";" delimiter just below it accepted it. I hit go about 10 minutes ago and it's still working. Is it possible a query would take so long or did I do something wrong?!

[familynow]

yet if I browse the wzc_products
SELECT COUNT( * ) AS `Rows` , `products_id`
FROM `wzc_products`
GROUP BY `products_id`
ORDER BY `products_id`
LIMIT 0 , 30

I get 69 pages returned(I have approx. 2,100 products)

[Limitless]

okay. So this is what I built from your example:

SELECT wzc_products.products_id as "Product ID", wzc_products_description.products_name as "Product Name", wzc_products.products_model as "Product Model", wzc_manufacturers_info.manufacturers_id as "Manufacturers ID", wzc_manufacturers.manufacturers_name as "Manufacturers Name"

FROM products
INNER JOIN wzc_products_description ON wzc_products_description.products_id = wzc_products.products_id
INNER JOIN wzc_manufacturers_info On wzc_products.manufacturers_id = wzc_manufacturers_info.manufacturers_id 
INNER JOIN wzc_manufacturers On wzc_manufacturers_info.manufacturers_id = wzc_manufacturers.manufacturers_id

I was getting an error "#1054 - Unknown column 'wzc_products.products_id' in 'field list' " but when I removed the ";" delimiter just below it accepted it. I hit go about 10 minutes ago and it's still working. Is it possible a query would take so long or did I do something wrong?!

I have 50k products and it returns all results in ~1 second.

Not sure which semicolon delimiter you are talking about?

I think you need to edit the

from products to from wzc_products...

[familynow]

I kinda thought so...

At the bottom of the SQL tab there is a "delimiter" field and a semicolon in it by default. If I leave the semicolon I get the aformentioned error. If I remove it the page jsut times out(blank). I guess I'll have to try with something other than phpmyadmin.

[Limitless]

I like heidisql (free) but you will have to add a mysql user/host to allow connection to your shared server from your PC.

[familynow]

I've been trying to connect using libreoffice base and just can't figure it out.

[Limitless]

Do you have the MySQL odbc connector installed and configured?


If you do not configure your MySQL server to allow remote connections from your IP, you will not get access to your data (regardless of tool).

[familynow]

Yeah I thought of that. I'm not certain how to do that in a shared enviro. Do you think that might be a setting I could adjust in phpmyadmin?

[Limitless]

Yes. You need to specify which hosts a user can connect from.

You will need your PC's IP address, you don't want to open it up to the world.