How to include php script

[Essie]

Hi,
I have a guestbook script that I would like to include it's entry into my cms pages.  I set up the user defined tag as {guestbook}.  In it, I wrote something like:

Code: Select all

include("/path/to/public_html/guestbook/stats.php");

@include('/path/to/public_html/guestbook/inc/database.inc.php');

Then in the template page, I inserted the {guestbook} tag.  But when I preview the page, I get an error message reading:

Code: Select all

Table 'tani_record.visitors' doesn't exist

I double checked the coding and tested it with a regular html web page and the guestbook stats show up at my website perfectly fine but it won't work with cms script.  What steps am I missing? 

[Dr.CSS]

Have you looked in the Documentation, it's in the tab up top.

I'm not so good with code unless it's html or CSS.

[calguy1000]

just make sure your included scripts aren't re-using the $db bariable that may cause you grief.

[Essie]

Hi Mark,
I did read the documentation.  That is why I am not sure what went wrong.

Hi Calguy1000,
Can you please be more specific as to what you mean by reusing $db Variable?  Or should I post the codes of the 2 included files here online?
Thanks.

[Dee]

CMSMS already has a variable called $db, representing the (ADOdb) database connection.
If your code also uses a (/re-uses the) (global) $db variable it gets overwritten so the queries get sent to the wrong db and the table cannot be found.