@lists = check_id($id);

print "In: @lists";

sub check_id {
 $ids = shift;

 $sthm = $dbh->prepare("SELECT name,parent FROM category WHERE id = '$
+ids'");
 $sthm->execute or die $dbh->errstr;

 ($name,$parent) = $sthm->fetchrow_array;
 push(@info, $name);

 if($parent ne "0") {
  $line = check_id($parent);
      push(@info, $line);
 }

 return(@info);
}

[download]
Say my $id was 11, then it would return. 
ff xx aa other 4 5 6

[download]
I have no idea why those numbers are there, there not suppost to be, heres what my table looks like in php my admin.
id name parent description view_cats_prod
Edit Delete 3 snowmobiles 0    
Edit Delete 4 other 0    
Edit Delete 5 parts 3    
Edit Delete 8 a 0 a a
Edit Delete 9 aa 4 aa no
Edit Delete 10 xx 9 d no
Edit Delete 11 ff 10 ss no
Edit Delete 12 dd 0 ff no
Edit Delete 13 dd 0 ff no
Edit Delete 17 a 12 x yes
Edit Delete 15 a 0 a yes

In reply to Looping through MySQL by andrew

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.