StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>You could loop through the entire data set, keeping track of the <code>portfolio_id</code> of each row. Then, each time the <code>portfoio_id</code> changes, start a new list.</p> <p>If I'm understanding correctly, this should help. Here's how you could separate a generic set of images into different unordered lists using <code>group_id</code> to define groups:</p> <pre><code>// select the entire set, group by whichever field defines your groups $result = mysql_query("SELECT image_path FROM portfolio ORDER BY group_id"); // the group_id associated with the currently growing <ul> $current_id = null; while ($row = mysql_fetch_array($result)) { $group_id = $row['group_id']; // the first list if (is_null($current_id)) { $current_id = $group_id; echo "<ul>\n"; } // if a new group_id is encountered, close the list and start a new one elseif ($group_id != $current_id) { $current_id = $group_id; echo "</ul>\n\n<ul>\n"; } echo "<li><image src=\"" . $row['image_path'] . "\"></li>\n"; } echo "</ul>\n"; </code></pre> <p>The table looks like this:</p> <pre><code>mysql> SELECT * FROM portfolio; +------------+----------+ | image_path | group_id | +------------+----------+ | a.png | 1 | | b.png | 3 | | c.png | 4 | | d.png | 3 | | e.png | 3 | | f.png | 1 | | g.png | 4 | +------------+----------+ 7 rows in set (0.00 sec) </code></pre> <p>And the output of the above program looks like this:</p> <pre><code><ul> <li><image src="a.png"></li> <li><image src="f.png"></li> </ul> <ul> <li><image src="b.png"></li> <li><image src="d.png"></li> <li><image src="e.png"></li> </ul> <ul> <li><image src="c.png"></li> <li><image src="g.png"></li> </ul> </code></pre>

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