StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSorting related pictures to artists - PHP/MySQL
primarykey
Id
4651181
data
AcceptedAnswerId
4651301
AnswerCount
4
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-01-10T20:28:21.123
FavoriteCount
0
LastActivityDate
2011-01-11T22:23:24.270
LastEditDate
2011-01-11T22:23:24.270
LastEditorUserId
2682174
OwnerUserId
2682174
ParentId
0
PostTypeId
1
Score
0
ViewCount
266
LastEditorDisplayName
text
Body
I need anyones help, i'll really appriciate that. I have made 2 JOiN-s. As a fact I have 3 Tables <ol> <li>Table with names of Artists (m)</li> <li>Table with Product iformations, in this case Picture addresses (p)</li> <li>Table that has id of Artists and id of Products. (pmx)</li> </ol> here's the SELECT statement: <pre><code>SELECT m.manufacturer_id , m.mf_name , p.product_id , p.product_full_image FROM jos_vm_product_mf_xref AS pmx JOIN jos_vm_manufacturer AS m ON m.manufacturer_id = pmx.manufacturer_id JOIN jos_vm_product AS p ON p.product_id = pmx.product_id WHERE m.mf_chars = 'm' </code></pre> the effect that I'm trying to achieve is like on [http://www.ugallery.com/ArtistList.aspx?RC=1][1] and in fact I'm getting just: <ol> <li>Name1 - prod1</li> <li>Name1 - prod2</li> <li>Name2 - prod1</li> <li>Name1 - prod3</li> </ol> I want it, after foreach (smth) { smth } to get: <ol> <li>Name1 - prod1 prod2, prod3</li> <li>Name2 - prod1 prod2</li> <li>Name3....etc <pre><code><ul> <?php foreach ($this->artistlist as $item) { ?> <li><a href="index.php?option=com_virtuemart&page=shop.browse&manufacturer_id=<?php echo $item->manufacturer_id; ?>"><?php echo $item->mf_name; ?></a> <a href="index.php?page=shop.product_details&flypage=flypage.tpl&product_id=<?php echo $item->product_id; ?>&option=com_virtuemart"> <img src="components/com_virtuemart/shop_image/product/<?php echo $item->product_full_image; ?>" height="75px"> </a> </li> <?php } ?> </ul> </code></pre></li> </ol> this is PHP code that I'm using for now... So plz, plz, plz.... Can anyone help me? Here's the piece of the code <pre><code>foreach ($this->artistlist as $picture) { if(!isset($artists[$picture['manufacturer_id']])) { <---this is line 22 $artists[$picture['manufacturer_id']] = array( 'name'=>$picture['mf_name'] ); } </code></pre> So... the error: Warning: Invalid argument supplied for foreach() in D:\Server\xampp\htdocs\ta\components\com_artists\views\artists\tmpl\default.php on line 35 foreach($artist['pictures'] as $pictureId=>$pictureFullImage) { <--- line 35 And another additional question: the outputed HTML is like this: <pre><code> <ul> <li> <a href="/ta/index.php?option=com_virtuemart&amp;page=shop.browse&amp;manufacturer_id=3">Giorgi Mihkeil</a> **</li><li>** <--- and, can we get rid of this pieces? *<a href="/ta/index.php?option=com_virtuemart&amp;page=shop.browse&amp;manufacturer_id=$picture->artist_id"></a>* <-- what is this link? where does it come from? <a href="/ta/index.php?page=shop.product_details&amp;flypage=flypage.tpl&amp;product_id=1&amp;option=com_virtuemart"> <img src="/ta/components/com_virtuemart/shop_image/product/Lonely_Boat_4cfa773e83874.jpg" height="75px"> </a> <a href="/ta/index.php?page=shop.product_details&amp;flypage=flypage.tpl&amp;product_id=2&amp;option=com_virtuemart"> <img src="/ta/components/com_virtuemart/shop_image/product/Naked_Couple_4cfbd12805f5b.jpg" height="75px"> </a> <a href="/ta/index.php?page=shop.product_details&amp;flypage=flypage.tpl&amp;product_id=4&amp;option=com_virtuemart"> <img src="/ta/components/com_virtuemart/shop_image/product/Lonely_Boat_4d246dbef30e1.jpg" height="75px"> </a></li></ul> </code></pre> now this html give's smth like: <code><ul><li>NAME </li><li> <img1><img2><img3> </li></ul></code> can we get smth like: <code><ul><li>NAME <img1><img2><img3> </li></ul></code> ?
Tags
<php><mysql>
Title
Sorting related pictures to artists - PHP/MySQL
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USmrGott
UserOwnerUserId
1. USmrGott
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.