Citat:
Nikola Poša: Nisam lepo napisao upit, treba sc.subcategory_subcategoryid, umesto sc.id. :) Jako su ti neobični ti nazivi kolona... :)
promenio sam ja to i dobijem ono sto sam napisao u prethodnom postu.
znaci, izlista mi prvo kategoriju, pa podtakegoriju, pa onda drugu kategoriju, zatim drugu podkategoriju, i nije poredjano tipa kategorija, pa onda da mi izlista sve podkategorije te kategorije.
Code:
$query = mysql_query("SELECT sc.subcategory_subcategoryid AS 'subcategory_id', sc.subcategory_title AS 'subcategory', c.category_title AS 'category', COUNT(a.articles_postid) AS 'sc_count'
FROM category c, subcategory sc, articles a
WHERE a.articles_subcategoryid = sc.subcategory_subcategoryid AND sc.subcategory_subcategoryid = c.category_categoryid
GROUP BY sc.subcategory_subcategoryid") or die(mysql_error());
$output = '<select name = "lista">
';
$marker = '';
while($row = mysql_fetch_assoc($query))
{
if ($marker != $row['category']) {
$output .= '<option disabled="disabled">' . $row['category'] . '</option>';
$marker = $row['category'];
}
$output .= '<option value = "' . $row['subcategory_id'] . '">' . $row['subcategory'] . ' (' . $row['sc_count'] . ')</option>';
}
$output .= '</select>';
echo $output;
$query = mysql_query("SELECT sc.subcategory_subcategoryid AS 'subcategory_id', sc.subcategory_title AS 'subcategory', c.category_title AS 'category', COUNT(a.articles_postid) AS 'sc_count'
FROM category c, subcategory sc, articles a
WHERE a.articles_subcategoryid = sc.subcategory_subcategoryid AND sc.subcategory_subcategoryid = c.category_categoryid
GROUP BY sc.subcategory_subcategoryid") or die(mysql_error());
$output = '<select name = "lista">
';
$marker = '';
while($row = mysql_fetch_assoc($query))
{
if ($marker != $row['category']) {
$output .= '<option disabled="disabled">' . $row['category'] . '</option>';
$marker = $row['category'];
}
$output .= '<option value = "' . $row['subcategory_id'] . '">' . $row['subcategory'] . ' (' . $row['sc_count'] . ')</option>';
}
$output .= '</select>';
echo $output;
izlaz je:
Code:
<select name = "lista">
<option disabled="disabled">Example Category 1</option>
<option value = "1">Example subcategory 1 (2)</option>
<option disabled="disabled">Example Category 2</option>
<option value = "2">Example subcategory 2 (1)</option>
<option disabled="disabled">Example Category 3</option>
<option value = "3">Example subcategory 3 (1)</option>
</select>
<select name = "lista">
<option disabled="disabled">Example Category 1</option>
<option value = "1">Example subcategory 1 (2)</option>
<option disabled="disabled">Example Category 2</option>
<option value = "2">Example subcategory 2 (1)</option>
<option disabled="disabled">Example Category 3</option>
<option value = "3">Example subcategory 3 (1)</option>
</select>
a trebalo bi:
Code:
<select name="lista">
<option disabled="disabled">Example Category 1</option>
<option value="1">Example subcategory 1 (2)</option>
<option value="2">Example subcategory 2 (1)</option>
<option disabled="disabled">Example Category 2</option>
<option value="3">Example subcategory 3 (1)</option>
<option value="4">Example subcategory 4 (0)</option>
<option disabled="disabled">Example Category 3</option>
</select>
<select name="lista">
<option disabled="disabled">Example Category 1</option>
<option value="1">Example subcategory 1 (2)</option>
<option value="2">Example subcategory 2 (1)</option>
<option disabled="disabled">Example Category 2</option>
<option value="3">Example subcategory 3 (1)</option>
<option value="4">Example subcategory 4 (0)</option>
<option disabled="disabled">Example Category 3</option>
</select>
znaci, kategorija 1 ima 2 podkategorije, kategorija 2 ima 2 podkategorije, kategorija 3 nema nijednu podkategoriju.
a ovde mi izlista kategoriju, pa podkategoriju, pa opet kategoriju, pa onda opet podkategoriju, i to nije nista povezano, tj, nije poredjana svaka podkategorija za svaku odredjenu kategoriju.