HTML coding in the database

[MachaNeko]

I have no idea if this goes in here.

my boss wants to add a line of html code onto every single page we have by sending a line of sql through the database.

can this be done the way he wants? can this be done at all in any way?

[kuroi]

Certainly this can be done, but not in the way being suggested.

Could you tell us more about what this line is and where on each page it should appear. Then we'll be able to advise on appropriate options.

[MachaNeko]

its this html code:

<font color="#800000">
<h3>Reminder!</h3>
Call us for unadvertised specials and discounts! 866-856-6100
</font>


and its supposed to be in the same place as the reminder is on this page.
My Site

this reminder you see is an attribute but my boss wants this to be removed and replaced by the html from above. i dont need how to substitute the html for attribute or anything i am merely saying this is the eventual placement.

[kuroi]

Putting to one side that this uses a deprecated (soon to disappear) font tag, is it only intended to appear on product pages, or all pages as stated earlier? If it is still all pages, where should it appear on non-product pages?

[MachaNeko]

aw crap again with the depreciation? which tag?

it should only appear in the product pages where it has a description.

[MachaNeko]

no one knows how this is entered?
he messed up the database when he tried adding an sql statement.

[kuroi]

The problem here is that it's still not clear exactly where you want this text to appear.

If it is anywhere where there is a product description it would indeed need to be added to the product description in the database for each product. But that's going to look very repetitive on the product listings pages. And would need to be added to each new product.


If it was only to appear on the product information page for each individual product, then it would be better to add it directly to the product_info page template.

[MachaNeko]

i understand what you mean but i was hoping to avoid all that. there is over 200 products and its such a pain.

all i want is the text to appear right under where it says product dimensions or no product dimensions.

what is this template you speak of?

[kuroi]

That's in the middle of the product description, so you can only get there by inserting the text in each product's description in the database, which I wouldn't recommend either.

Better would be to put it above the dimension information, in which case you could insert it just once into your includes/templates/red_passion/templates/tpl_product_info_display.php file.

[MachaNeko]

every time i touch that file the site dies. i have no idea why.

could you give me the line where to add this text and any code you know of please? I'll see if my boss can do this.