You are here : Home - Resources - RSS Feed Directory

RSS Feed Directory

RSS Feed Directory "; //show categories from provider if(isset($cat)){ $result = mysql_query("SELECT rss_provider, rss_cat FROM rss WHERE rss_provider ='$provider' ORDER BY rss_cat") or (mysql_error()); //$row = mysql_fetch_row($result); //if($row[1] != "CSM"){ //put values into array while ($row = mysql_fetch_row($result)){ $myarray[] = $row[1]; if($row[1]=="No Cat"){$sub="No Cat";} } //remove duplicate entries if(!isset($sub)){ $myarray = array_unique($myarray); //renumber key values $i=0; foreach ($myarray as $a) { $mynewarray[$i] = $a; $i++; } //display the new array echo " - $provider
"; echo ""; for ($i=0; $i < count($mynewarray); $i++){ $result_count = mysql_query("SELECT rss_subcat FROM rss WHERE rss_cat = '$mynewarray[$i]'") or (mysql_error()); $result_count = MYSQL_NUMROWS($result_count); echo ""; }//end for echo "
$mynewarray[$i]    ( $result_count )
"; } }//end $cat if(isset($sub)){ if ($sub == "No Cat"){ echo " - $provider
"; } else { echo " - $provider - $sub
"; } $result = mysql_query("SELECT * FROM rss WHERE rss_cat ='$sub' AND rss_provider = '$provider' ORDER BY rss_subcat") or (mysql_error()); //put values into array while ($row = mysql_fetch_row($result)){ $mycatarray[] = $row[3]; $myurlarray[] = $row[4]; } echo "
\n"; for ($i=0; $i < count($mycatarray); $i++){ $myurl = $myurlarray[$i]; $myurl = preg_replace("/\//","/",$myurl); $myurla = urlencode($myurlarray[$i]); echo "\n\n
$mycatarray[$i]
\n
$myurl
preview feed
\n"; } echo "
\n\n"; echo " get this directory as xml (do not link directly to this feed) "; } //if no category show providers if(!$QUERY_STRING){ echo "
Providers"; $result = mysql_query("SELECT rss_provider FROM rss") or (mysql_error()); //$row = mysql_fetch_row($result); $number = mysql_numrows($result); //put values into array while ($row = mysql_fetch_row($result)){ $myarray[] = $row[0]; } //remove duplicate entries $mytmparray = array_unique($myarray); //renumber key values $i=0; foreach ($mytmparray as $a) { $mynewarray[$i] = $a; $i++; } sort($mynewarray); //display the new array echo ""; for ($i=0; $i < count($mynewarray); $i++){ $result_count = mysql_query("SELECT rss_cat, rss_subcat FROM rss WHERE rss_provider = '$mynewarray[$i]'") or (mysql_error()); $result_counter = MYSQL_NUMROWS($result_count); while ($rowa = mysql_fetch_row($result_count)){ $myarraya[] = $rowa[0]; } $catcount = array_unique($myarraya); //$catcount = count($catcount); $catcount = count($catcount) ; unset($myarraya) ; echo ""; } echo "
$mynewarray[$i]    ( $result_counter Feeds ) ( $catcount Categories )
"; $number = MYSQL_NUMROWS($result); echo "
( $number Feeds )  
"; } ?>
Suggest an RSS Feed Source