Public feed #887916

Mine

public text v1 · immutable
Raw Edit
·published 2008-02-01 18:36 UTC
rendered paste body
	   function subcatnavpc()
   {
      $catid = $_REQUEST['catid'];
	  
    $query  = "SELECT * FROM subcategory WHERE $catid IN(tag_1, tag_2, tag_3, tag_4, tag_5)";
    $result = mysql_query($query);

    if(mysql_num_rows($result) == 0){
        exit("Nothing to Display!");
    }
    while($row = mysql_fetch_array($result)){
        if ($bgcolor == "#E0E0E0"){
            $bgcolor = "#FFFFFF";
        }else{
            $bgcolor = "#E0E0E0";
        }

        
        $id = $row['id'];
        $name = $row['name'];


	echo "<a href='$PHP_SELF?catid=$catid&subcatid=$id'>$name</a<br>";
	
	}
	}