Print Text Opposite Way Around

[jonno946]

Hi there,

Just a bit of a quickie really, well, i presume it is anyway...

I have made (with a bit of assistance off here - cheers guys!) a breadcrumb script, which outputs the users current position on the forum for example home > forum 1 > forum 2...

It all works ok, appart from one thing... The categories are the wrong way around!!

So instead of appearing:

Hardware > Processors > AMD > Athlon

It appears:

Athlon > AMD > Processors > Hardware

Anyone how to prevent this from happening?

My code is printed below:

    $result = mysql_query("select * from forums where id=$id");
    $item = mysql_fetch_object($result);
    $parent = "$item->parent";
    echo "Forums > $item->name > ";
    while($parent != "0") { 
        $result2 = mysql_query("select * from forums where id=$parent");
        $item2 = mysql_fetch_object($result2);
        echo "$item2->name > ";
        $parent = "$item2->parent";  

    }

Thanks For Your Time,

Regards,

Jonathan

[tekky]

Originally posted by jonno946

So instead of appearing:

Hardware > Processors > AMD > Athlon

It appears:

Athlon > AMD > Processors > Hardware

Anyone how to prevent this from happening?

My code is printed below:

    $result = mysql_query("select * from forums where id=$id");
    $item = mysql_fetch_object($result);
    $parent = "$item->parent";
    echo "Forums > $item->name > ";
    while($parent != "0") { 
        $result2 = mysql_query("select * from forums where id=$parent");
        $item2 = mysql_fetch_object($result2);
        echo "$item2->name > ";
        $parent = "$item2->parent";  

    }

Thanks For Your Time,

Regards,

Jonathan [/B]

Easy...

your function appends the parent of the current item...
so your user is in "bedroom" your function then gets its parent "east wing" prints that... then gets ITS parent... "mansion on the hill" which prints then gets ITS parent, "city by the sea" etc etc.... your iterating the wrong way basically... need to reverse your process... I'll try and help you out, just give me a bit to think about it 😉

[HalfaBee]

Why dont you read the results into an array and echo it out backwards.

HalfaBee

[tekky]

    $result = mysql_query("select * from forums where id=$id");
    $item = mysql_fetch_object($result);
    $parent = "$item->parent";
    $prefix = "Forums > ";
    $postfix = "$item->name > ";
    while($parent != "0") { 
        $result2 = mysql_query("select * from forums where id=$parent");
        $item2 = mysql_fetch_object($result2);
        $str = "$item2->name > " .$str;
        $parent = "$item2->parent";  

    }
     $str = "$prefix$str$postfix";

I think that will work...