[mhillman159]

Hi all,

I have a question I need help with. I'm using a CMS system for our business which displays the html title using the product name. I have set up some extended fields in this system so that I can code the template to use these text boxes as metadata. Basically its 3 sets of extended fields in each product that I want to use for SEO.

The boxes I have are:

Meta Title
Meta Keywords
Meta Description.

I want to be able to code our template to bring in the information in these extended fields to use as SEO for each product. I don't know php well enough to code this myself so need some help please!

As an example if I'm not clear, In the product level of our CMS we have an extended field called Meta Title. I want to be able to fill out this box in the Product to say something else rather than the product name that it currently uses, so if the product is a Bath Thermometer I want to be able to fill our Meta Title extended field in the product to say something more descriptive about the product in effect overrighting the original html title to what the Meta Title extended field says.

Hope someone can help me ASAP!

[paulanthony]

Find your SQL statement in your SQL, bring back those additional fields, echo them out.

Simple really.


If you are still stuck. Hows about hiring someone, this should be a job posting really.

[mhillman159]

All I need to know is how to bring in the data from an extended field as meta data in php I can work out the rest....

[Cheeto]

SQL queries are wonderful! Once you learn them... it makes life easier...

PHP: MySQL - Manual - php SQL functions
SQL Tutorial - SQL queries themselves...