Jump to content
Sign in to follow this  
alvaroceballos

How to get full cat path?

Recommended Posts

Hi:

 

I am skining my oscommerce 2.3 file by file, and I am making a module for am improved cat listing on index (only certain cats).

 

I want to know, if there is a fast way, from a categories ID, to get the full cat for making the URL to it.

 

From a given categories number, IE:

Category id 4817

Full path to 4817 21_29_4751_4746_4817

 

Is there any other way to make the URL link o a given cat? or to generate the full cPath from a cat id?

 

I hope I explained myself correctly.

Share this post


Link to post
Share on other sites

Finaly I wrote a quite simple function, with works fine for me.

I only call that function if cPath does not contain "_" string.

 

 

function get_full_cat_from_cPath ($zipote)
{

$query_trabajo_1=tep_db_query("SELECT `parent_id` FROM `categories` WHERE `categories_id` =  '" . $zipote . "'");
$land = tep_db_fetch_array($query_trabajo_1);
$cat_completa = $zipote;
while (! $land[parent_id] == 0) {
$query_ciclica=tep_db_query("SELECT `parent_id` FROM `categories` WHERE `categories_id` =  '" . $land[parent_id] . "'");
$land=tep_db_fetch_array($query_ciclica);
if (! $land[parent_id] == 0) {
$cat_completa = $land[parent_id] . '_' . $cat_completa;
}
}
return $cat_completa;
}

Share this post


Link to post
Share on other sites

Wouldn't it be easier to just use

substr(tep_get_path($category_id), 6)

Regards

Jim


See my profile for a list of my addons and ways to get support.

Share this post


Link to post
Share on other sites

Documentation on the code? No, you just have to read through it. It gets easier with experience.

 

Regards

Jim


See my profile for a list of my addons and ways to get support.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×