Resolving Category Page Url By Code

General General Questions
1

hi. currently Im reading via PHP the CSCart dbase via 

select * from cscart_categories 
left join cscart_category_descriptions on cscart_category_descriptions.category_id = bb.category_id

I have the category_id, how I can create the category URL by code ex. :

when browsing normally is like :

http://x.x/citroen/citroen-saxo/saxo-s0-s1/1.000cc/1.0-x-50hp-b-cdz-tu9m-05-1998-06-2003/

is any quick way?? like :

http://x.x/citroen/category=943
thanks!
2

hi. currently Im reading via PHP the CSCart dbase via 

select * from cscart_categories 
left join cscart_category_descriptions on cscart_category_descriptions.category_id = bb.category_id

I have the category_id, how I can create the category URL by code ex. :

when browsing normally is like :

http://x.x/citroen/citroen-saxo/saxo-s0-s1/1.000cc/1.0-x-50hp-b-cdz-tu9m-05-1998-06-2003/

is any quick way?? like :

http://x.x/citroen/category=943
thanks!

Unfortunately, some PHP code changes are required to be made to implement this feature. You can make them yourself (if you know PHP) or hire a third-party developer.

3

hi. currently Im reading via PHP the CSCart dbase via 

select * from cscart_categories 
left join cscart_category_descriptions on cscart_category_descriptions.category_id = bb.category_id

I have the category_id, how I can create the category URL by code ex. :

when browsing normally is like :

http://x.x/citroen/citroen-saxo/saxo-s0-s1/1.000cc/1.0-x-50hp-b-cdz-tu9m-05-1998-06-2003/

is any quick way?? like :

http://x.x/citroen/category=943
thanks!

You can use the following format:

http://x.x/citroen/index.php?dispatch=categories.view&category_id=943
4

@eComLabs thanks mate! working! :)