Want individual categories to slidedown instead of all of th
This is a bit of a tough one for me. I have tried using a for loop, but that didn't work, at least the way I tried it didn't work. The way my code is set up using JQuery, PHP and MySQL, when you click on a category the subcategories slide down to reveal themselves. Right now you can click on one category and all categories slide their subcategories down. I want only the one category to slide its subcategory down. Any thoughts?
Separate JQuery file:
var category = ".category_{$list['make']}";
$(function() {
$('.subcat').hide();
$(category.' > a').click(function() {
$('.subcat').slideToggle('normal');
});
});
HTML/PHP page
$listCats = "SELECT category_make.make
FROM category_make
ORDER BY make";
$catsListed = mysql_query($listCats) or die("List didn't work because: " . mysql_error());
echo "<table class='table-specs' cellspacing='0'>";
if(mysql_num_rows($catsListed) > 0) {
$i=0;
while($list = mysql_fetch_array($catsListed)) {
if($i==0)
echo "<tr>";
echo "<td><div class='category'><a>{$list['make']}</a></div>
<div class='subcat'>";
$dropModel = "SELECT category_model.model, category_model.model_make, category_make.make, category_make.id
FROM category_model
LEFT JOIN category_make
ON category_model.model_make = category_make.id
WHERE category_make.make = '{$list['make']}'
AND category_model.model_make = category_make.id
ORDER BY category_model.model";
$modelDropped = mysql_query($dropModel) or die("No drop because: " . mysql_error());
while($subcat = mysql_fetch_array($modelDropped)) {
echo "<a href='#'>- " . $subcat['model'] . "</a>";
}
echo "</div></td>
<td><div class='supervisor'>supervisor needed</div></td>";
$i++;
if($i==2)
echo "</tr>";
$i=0;
}
}
echo "</table>";