an example of how to accompish this is line 51 - 69.
<?php do { ?>
<li class="parent"><a href="#" style="background-image:url(CSSMenuWriter/cssmw_images/plus.png)"><?php echo $row_menuwriter_ps4categories["CategoryName"]; ?></a>
<?php
// MenuWriter Nested Filter Variable
$_POST["menuwriter_ps4categories1_CategoryID"] = $row_menuwriter_ps4categories["CategoryID"];
?>
<?php
$MenuWriter_menuwriter_ps4categories1 = "-1";
if (isset($_POST['menuwriter_ps4categories1_CategoryID'])) {
$MenuWriter_menuwriter_ps4categories1 = $_POST['menuwriter_ps4categories1_CategoryID'];
}
mysql_select_db($database_powerstore, $powerstore);
$query_menuwriter_ps4categories1 = sprintf("SELECT CategoryName, CategoryID, CategoryParent FROM ps4_categories WHERE CategoryParent=%s ORDER BY CategoryName ASC", GetSQLValueString($MenuWriter_menuwriter_ps4categories1, "int"));
$menuwriter_ps4categories1 = mysql_query($query_menuwriter_ps4categories1, $powerstore) or die(mysql_error());
$row_menuwriter_ps4categories1 = mysql_fetch_assoc($menuwriter_ps4categories1);
$totalRows_menuwriter_ps4categories1 = mysql_num_rows($menuwriter_ps4categories1);
?>
<ul class="level-1">
<?php if ($totalRows_menuwriter_ps4categories1 > 0) { // Show if recordset not empty ?>
This needs to be rearranged so the menuwriter_ps4categories1 recordset is just after the do statement that starts the loop. and add an ifstatment for the inline style:
<?php do { ?>
<?php
$MenuWriter_menuwriter_ps4categories1 = "-1";
if (isset($_POST['menuwriter_ps4categories1_CategoryID'])) {
$MenuWriter_menuwriter_ps4categories1 = $_POST['menuwriter_ps4categories1_CategoryID'];
}
mysql_select_db($database_powerstore, $powerstore);
$query_menuwriter_ps4categories1 = sprintf("SELECT CategoryName, CategoryID, CategoryParent FROM ps4_categories WHERE CategoryParent=%s ORDER BY CategoryName ASC", GetSQLValueString($MenuWriter_menuwriter_ps4categories1, "int"));
$menuwriter_ps4categories1 = mysql_query($query_menuwriter_ps4categories1, $powerstore) or die(mysql_error());
$row_menuwriter_ps4categories1 = mysql_fetch_assoc($menuwriter_ps4categories1);
$totalRows_menuwriter_ps4categories1 = mysql_num_rows($menuwriter_ps4categories1);
?>
<li class="parent"><a href="#" <?php if ($totalRows_menuwriter_ps4categories1 > 0) { ?>style="background-image:url(CSSMenuWriter/cssmw_images/plus.png)<?php } ?>"><?php echo $row_menuwriter_ps4categories["CategoryName"]; ?></a>
<?php
// MenuWriter Nested Filter Variable
$_POST["menuwriter_ps4categories1_CategoryID"] = $row_menuwriter_ps4categories["CategoryID"];
?>
<ul class="level-1">
<?php if ($totalRows_menuwriter_ps4categories1 > 0) { // Show if recordset not empty ?>