query, display and grouping.. one way works but not another
| From: | Aaron Wolski | Date: | Sat, 26 Jul 2003 14:37:28 +0000 |
| Subject: | query, display and grouping.. one way works but not another | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29491@lists.php.net to get a copy of this message | ||
Hi Guys,
Have a multiple select box. I'm trying to group columns and display
records under their paired groupings.
Code:
echo "<select name=\"patternThreads[]\" size=\"10\" multiple
style=\"font-family:monospace;\">\n";
$query = "select t.manufacturer, t.id, t.colour, t.colourID, t.type,
p.thread_index FROM kcs_threads t LEFT JOIN kcs_patternthreads p ON t.id
= p.thread_index WHERE p.pattern_index = '$id' OR p.pattern_index IS
NULL ORDER BY t.manufacturer, t.type";
$thread_manufacturer = '';
$thread_types = '';
$result = db_query($query);
while($thread = db_fetch($result)) {
if($thread_manufacturer !=
$thread['manufacturer']) {
echo "<option value=\"\"
class=\"adminEditLink\">{$thread['manufacturer']}</option>\n";
$thread_manufacturer =
$thread['manufacturer'];
}
if($thread_types != $thread['type']) {
echo "<option value=\"\"
class=\"adminEditLink\">{$thread['type']}</option>\n";
$thread_types =
$thread['type'];
}
}
echo "</select>\n";
The above does work.. but it displays the results like:
Manufacturer
Type
Manufacturer
Type
Manufacturer
Type
Etc..
What I'd like is to display them like:
Manufactuer - Type
Manufacturer - Type
Manufacturer - Type
I tried this code but only seems to group one TYPE and move onto the
next manufacturer and group that type.:
echo "<select name=\"patternThreads[]\" size=\"10\" multiple
style=\"font-family:monospace;\">\n";
$query = "select t.manufacturer, t.id, t.colour, t.colourID, t.type,
p.thread_index FROM kcs_threads t LEFT JOIN kcs_patternthreads p ON t.id
= p.thread_index WHERE p.pattern_index = '$id' OR p.pattern_index IS
NULL ORDER BY t.manufacturer, t.type";
$thread_manufacturer = '';
$thread_types = '';
$result = db_query($query);
while($thread = db_fetch($result)) {
if($thread_manufacturer !=
$thread['manufacturer']) {
echo "<option value=\"\"
class=\"adminEditLink\">{$thread['manufacturer']}";
$thread_manufacturer =
$thread['manufacturer'];
}
if($thread_types != $thread['type']) {
echo " -
{$thread['type']}";
$thread_types =
$thread['type'];
}
echo "</option>\n";
}
echo "</select>\n";
Any idea's where I am going wrong?
Thanks!!!
Aaron