Forum Moderators: coopster

Message Too Old, No Replies

osCommerce / FCKeditor help

         

adammc

11:38 pm on Apr 22, 2007 (gmt 0)

10+ Year Member



Hi folks,

How does one go about adding a PHP / MYSQL call on the shipping info & privacy page in OsCommerce?

I am using FCKeditor on the other areas of my clients site, storing the html into a MYSQL DB. What I need to be abel to do is add a call to extract the data from the DB.

Where on the shipping page can I add this call?

// Perform the query

$query = mysql_query("SELECT content FROM CMS_content WHERE page_id='14'");
while($r = mysql_fetch_assoc($query))
{
$content = html_entity_decode ($r[content]);
echo "$content";
}

// end of query

Any help would be greatly appreciated.

eelixduppy

12:08 am on Apr 23, 2007 (gmt 0)



>> Where on the shipping page can I add this call?

You can add the code wherever you want the html to be echoed. I'm not familiar with the layout so I can't be of help there. Add it where you want it.

Also, don't forget to properly connect to the db server and select a database :)

I hope I haven't misunderstood your question.

adammc

2:52 am on Apr 23, 2007 (gmt 0)

10+ Year Member



Thanx eelixpuppy.

I hadnt bother trying to just add that call in, I just assumed it wouldnt work.

However.. it works a treat :)