function subcatnavpc() { $catid = $_REQUEST['catid']; $query = "SELECT * FROM subcategory_new WHERE LOCATE(';".$catid.";',parent) > 0 ORDER BY name ASC"; $result = mysql_query($query); if(mysql_num_rows($result)==0){ return("Nothing to Display!"); } while($row = mysql_fetch_array($result)){ if ($bgcolor == "#E0E0E0"){ $bgcolor = "#FFFFFF"; }else{ $bgcolor = "#E0E0E0"; } $id = $row['id']; $name = $row['name']; echo "$name
"; } }