Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

display current category name


neo_digital

Recommended Posts

just do a sql query & display results. If you need more help state your skill level.

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

thats a problem - I don't know sql :(

 

Do you know php or html?

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

yes I know, but I don't know how to write sql query, because in product table there is no information about product category and I don't know how to get it with ql query

 

thanks for your reply

 

 

Ok this should do it, I`ve just writ it off the top of my head, so no guarantee there`s no errors.

 

$category_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where cd.categories_id = pc.categories_id and pc.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and cd.language_id = '" . (int)$languages_id . "'");$cateqory = tep_db_fetch_array($category_query);echo $cateqory['categories_name'];

 

;)

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...