All pastes #290630 Raw Edit

Miscellany

public text v1 · immutable
#290630 ·published 2006-12-24 05:34 UTC
rendered paste body
//Additional categories for search
	 	ob_flush();
 
  ob_start();
  	$sql = "select catname,id from categories where supercat = -1 order by catname ASC";
	$query = mysql_query($sql);
	$maincats = array();
	while($row = mysql_fetch_array($query))
	{
		$maincats[] = $row['id'];
		$supercat = $row['id'];
		
  	
		$newsql = "select catname, id from categories where supercat = ".$supercat." order by catname ASC";
		$newquery = mysql_query($newsql);
		echo "catState.forValue(\"$row[catname]\").addOptions(";
		while($newrow = mysql_fetch_array($newquery))
		{
			echo count($maincats);
			phpinfo();
			$maincats[count($maincats)-1][] = $newrow['id'];
			
			if($i != 0)
				echo ",\"".addslashes($newrow['catname'])."\"";
			else
				echo "\"".addslashes($newrow['catname'])."\"";
		
			$i++;
		}
	}