StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSQL statement on a product database with multiple tables to extract image names
text
Body
copied!<p>I've got an ecommerce database where I'm trying to export all of the image names associated with a product into a csv file.</p> <p>I'm writing it in php and running the script through the admin of the ecommerce system but I'm struggling to print out the results in a way I would like them.</p> <p>The two tables involved are: <code>CubeCart_inventory</code> which contains the product information, and <code>CubeCart_img_idx</code> which contains the associated images.</p> <p>The tables are linked by a 'productid' so in the first table the product id is: <code>CubeCart_inventory.productId</code> and in the image table the id <code>CubeCart_img_idx.productId</code>.</p> <p>Is there an SQL statement that I can use that puts all of the image names into a string which I can then use to write my csv on a product by product basis?</p> <p>Example of the CubeCart_inventory table:</p> <pre><code>id | productId | productname | price ____________________________________ 1 | 1234 | Bag of Nails | £35 </code></pre> <p>Example of the CubeCart_img_idx table</p> <pre><code>id | productId | img ____________________ 1 | 1234 | nails.jpg 2 | 1234 | nails2.jpg 3 | 5678 | otherproduct.jpg 4 | 1234 | nails3.jpg </code></pre> <p>So what I would like is: <code>nails.jpg</code>, <code>nails2.jpg</code>, <code>nails3.jpg</code> all in one field in my CSV file because they are joined by the same <code>productId</code></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload