include path problem

[garlinto]

I'm having a very frustrating include() path problem.

When I do this:

include 'config.php'; 

, I don't have a problem.
But when I try:

include '../config.php'; 

, I can't get it to work. The error I get is:

Warning: Failed opening '../config.php' for inclusion (include_path='.:/usr/share/pear') in /home/tandr/tandrtrailer.com/htdocs/ads/rotate.php on line 3
Error 1:You have an error in your SQL syntax near '' at line 1

I wanted to put my 'config.php' file in my cgi-bin so that it would be in a central location for my other scripts. I've done a search to learn about include paths here at sitepoint and learned a lot, but I still can't get it to work.

I'm sure the solution is very simple.

[tmapm]

Have you tried something along the lines of /cgi-bin/config.php ?

[markl999]

ini_set('include_path', ini_get('include_path').':/path/to/the/dir/config/will/be/in');
//this should allow you to include config.php from anywhere
include_once 'config.php'; 

[Dr Livingston]

What your basically doing is that you want to INCLUDE your config file which resides one directory up from where this PHP script actually is.

Your CGI [I do not have CGI] from what I remember is on the root directory of your PHP installation; ie Same directory level as HTDOCS isn't it not ?

So the directory path that you've choosen is wrong no in any event, if on the otherhand your CGI directory is one directory up from where you've put your script, then try this...

../cgi/config.php 

To see if that helps... If CGI is one directory up from where you've saved your script that is

[garlinto]

Thanks guys!
And thanks mark999 for the code snippet. I was actually doing some research to come up with code that would perform that same function! Thanks.

[garlinto]

ok...mark999:
I have this:

 ini_set('include_path', ini_get('include_path').':/path/to/the/dir/config/will/be/in'); 

I've tried a number of combinations but I can'y seem to get it right. The /path/to/the/dir/config/will/be/in/ is relative to what?

Do I write:

ini_set('include_path', ini_get('include_path').':/mysite.com/cgi-bin/php/');
// which is where the file is, actually 

...or what, exactly?

Sorry I'm so dense

[peanuts]

put this in your .htaccess file (in the root folder)

php_value include_path /home/tandr/tandrtrailer.com/htdocs/cgi-bin

if there isn´t a .htaccess file just make a new file and call it .htaccess and put this line in...

[garlinto]

This finally did it:

ini_set('include_path', ini_get('include_path').':/home/tandr/tandrtrailer.com/cgi-bin/php');
include_once 'config.php'; 

Thanks for all of the help