RE: [PHP] Reverse (or backward?) Infinity Loop
| From: | trenton at southfamily dot com | Date: | Wed, 20 Oct 2004 04:28:16 +0000 |
| Subject: | RE: [PHP] Reverse (or backward?) Infinity Loop | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-199846@lists.php.net to get a copy of this message | ||
This does not generate the exact look you are asking for, but can easily
be modified by changing the dashes to spaces etc. I also left my naming
convention in, so that would have to be altered to your fields as well.
It may not be the cleanest code, but it does work.
<?php
$query = "SELECT * FROM categories WHERE ca_caidParent = 0";
$result = mysql_query($query);
while ($row = mysql_fetch_object($result)) {
recursive($row->ca_caid,$row->ca_category,0,1);
}
function recursive ($id,$element,$tabs,$y) {
$dashes = str_repeat("---", $tabs);
echo "$dashes$element\n";
$result = "result$y";
$row = "row$y";
$$query = "SELECT * FROM categories WHERE ca_caidParent='$id'";
$$result = mysql_query($$query);
while ($$row = mysql_fetch_object($$result)) {
$tabs++;
$y++;
recursive($$row->ca_caid,$$row->ca_category,$tabs,$y);
$tabs--;
$y--;
$result = "result$y";
$row = "row$y";
}
}
?>
Trenton
-----Original Message-----
From: Bruno B B Magalhães [mailto:brunobbm@rio.com.br]
Sent: Tuesday, October 19, 2004 8:47 PM
To: php-general@lists.php.net; php-db
Subject: [PHP] Reverse (or backward?) Infinity Loop
Hi guys,
I have a normal categories table:
catId
catParentId
catName
catStatus
But I want when a user enters on:
http://hostname/site/products/catId1/catId7/catId13/../../contentId.html
A listing should apear like that:
Category 1
Category 7
Category 13
Category 2
Category 3
Category 4
Category 5
A reverse (or backward) loop! We need to get the last category and then
follow the ParentId until the 0 ParentId. Have anybody made this before
(I hope so)?
Many Thanks,
Bruno B B Magalhaes
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php