Adding additional fields to the products table

[CustomSoftwareUK]

Hi

 

Please can someone explain how to show additional fields. What I am trying to accomplish is add some fields to the products table and products_description table (e.g. track_listing and other_info). I can add the fields through phpmyadmin but I'm not sure how to add them to whatever .php file so they will show on the website.

 

Just some guidance or a pointer in right direction would be appreciated.

 

"Knowledge is a wonderful thing, if you know what you are talking about" :blink:

 

Many thanks

Lee

[ozcsys]

Hi

 

Please can someone explain how to show additional fields. What I am trying to accomplish is add some fields to the products table and products_description table (e.g. track_listing and other_info). I can add the fields through phpmyadmin but I'm not sure how to add them to whatever .php file so they will show on the website.

 

Just some guidance or a pointer in right direction would be appreciated.

 

"Knowledge is a wonderful thing, if you know what you are talking about" :blink:

 

Many thanks

Lee

 

Where are you wanting them to show on your site?? In the admin?? or where a customer can see the info as well??

 

Basically there are two parts to getting the extra info to show up. First you need to retreive the info from the database and then you have to display the info. A good file to look at to see how this is done might be the categories.php file in your admin. You can see where the file queries the database for info and then where it displays the info farther down the page

[CustomSoftwareUK]

Hi Richard

 

Thank you for your reply and sorry for the delay in posting back. In answer to your question, it fields the customer can see, for example, the site we are setting up has artist, title, price fields etc and I want to be able to add other fields (that I can add through myphpadmin) such as track listing, comments etc.

 

Hope that makes sense and here is what I've done so far www.cdx.co.uk/index.php

 

Many thanks

 

Lee