PHP - Moved: Website's Categories On Google

This topic has been Ctrl+X/Ctrl+V'd to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=347400.0

Hello, I am doing (well trying to do, anyway) a script where I need to follow a link, and through its source (file_get_contents) i need to to follow each "category" and into its "subcategory" (and sometimes even SUBsubcategory).
Lets say the first in the menu is called "Catfood", the second "Dogfood",
you click on "Catfood" and you get a submenu with for example "Whiskas", another one called "Purina Pro",
and you click "Whiskas" and you see a list of food called for example "Whiskas Junior Chicken" and "Whiskas Junior Fish".

then after i have followed "Whiskas", i need to go back and follow "Purina Pro".
then after "Purina Pro" i need to go back to "Dogfood" and do the same to its submenu + subsubmenu + food menu..

so yeah, thats pretty much it basically..
i have already used wget for windows to download the entire website to not put load on it all the time when trying stuff out..

i use RegEx to find categories, their products and price, and i got all that covered, it's just that the website isn't built very friendly for using Regex to tie lets say "Purina Pro" with being in the "Catfood" category, so i have to go through all categories and subcats to save the categories in maybe an array, and bind the subcategories to the main category ("Purina Pro" with "Catfood")

i hope this all doesn't sound too errr weird lol, any help is very much appreciated even enough to just get me started on my own! =)


****************** EDIT BELOW:

The menu looks a bit like this, though it's orinally not about cat or dogfood, they are just examples

Catfood
  - Whiskas
  - Purina Pro
Dogfood
  - Royal Canin
     - Puppy food
     - Grown
     - Senior
  - Bozita Robur

This topic has been moved to HTML Help.

http://www.phpfreaks.com/forums/index.php?topic=327455.0

Hello Guys,

Need a little help here. I have a db structure like this

cat_id |  cat_name | cat_status | parent_id
1        First Test         1                  0
2        Just testing       1                    0
4        Books               1                    2
5        Cars               1                    0
6        Ford               1                  5

If the parent_id = 0 it is considered to be the parent.
If it is a number it is considered a child and referencing the parent

I want to be able to query the database and grab the cat and the sub cat and echo it on my page. Its like a classified ads application.

Here is my while loop that I currently have which only echo's out the parent category. I would like to echo the child category under the respective parent category.

I think I would have to do a loop within a loop, but not sure how to do it..


$query  = "SELECT * FROM ad_category WHERE cat_status='1' && Parent_id='0' ORDER BY cat_name";
$result = mysql_query($query);

while($row = mysql_fetch_row($result))
{
   
    $cat_name = $row[1];
    

$cupper = UCWords($cat_name);

    echo $cupper . "<br>" ;
    
        
} 




Thanks for your help in advance

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=344127.0