mysql

[Wolfgang Lang]

Hello community!

I am successfully using mysql connections and operations in more than one
php file.
But when I want to use this in an included (required("head er.inc.php")) php
file but nothing happens except an error on
mysql_select.
Has mysql problems from included files or what could be the problem?

with kind regards
Wolfgang L.

[Shawn Wilson]

Wolfgang Lang wrote:

Hello community!

I am successfully using mysql connections and operations in more than one
php file.
But when I want to use this in an included (required("head er.inc.php")) php
file but nothing happens except an error on
mysql_select.
Has mysql problems from included files or what could be the problem?

with kind regards
Wolfgang L.

I'm not sure I understand the syntax you're using. It should be something like
this (note there is no "d" on the end of include or require):

include ("header.inc.ph p");
or
require ("header.inc.ph p");

If that's what you have, are you sure you have the path right? The syntax above
should be used if the include file is in the same directory as the script you're
including it in. Otherwise, you have to include path info. (i.e.
"../../header.inc.php" or "/home/yourdirectory/header.inc.php" )

Is the file actually being included? If you're not sure, type:

echo "<BR><BR>!!!FOO !!!<BR><BR>";

or similar on a line in the include file.

If that's prints out okay, maybe you should describe the mysql error you're
getting.

Regards,
Shawn

--
Shawn Wilson
sh***@glassgian t.com
http://www.glassgiant.com

[Wolfgang Lang]

"Shawn Wilson" <sh***@glassgia nt.com> wrote in message
news:3F******** *******@glassgi ant.com...

Wolfgang Lang wrote:

Hello community!

I am successfully using mysql connections and operations in more than one php file.
But when I want to use this in an included (required("head er.inc.php")) php file but nothing happens except an error on
mysql_select.
Has mysql problems from included files or what could be the problem?

with kind regards
Wolfgang L.
I'm not sure I understand the syntax you're using. It should be something

like this (note there is no "d" on the end of include or require):

include ("header.inc.ph p");
or
require ("header.inc.ph p");

If that's what you have, are you sure you have the path right? The syntax above should be used if the include file is in the same directory as the script you're including it in. Otherwise, you have to include path info. (i.e.
"../../header.inc.php" or "/home/yourdirectory/header.inc.php" )

Is the file actually being included? If you're not sure, type:

echo "<BR><BR>!!!FOO !!!<BR><BR>";

or similar on a line in the include file.

If that's prints out okay, maybe you should describe the mysql error you're getting.

Regards,
Shawn

the syntax is ok. the file is also included, because i get use of functions
in that specific file in other php
files.

On my local machine i get:
"2003 Can't connect to MySQL server on 'localhost' (10061)"

An on the sourceforge server i get:
"2002 Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)"

you can see it on http://fsth.sourceforge.net

[Wolfgang Lang]

"Wolfgang Lang" <la***********@ aon.at> wrote in message
news:3f******** *************** @newsreader01.h ighway.telekom. at...

"Shawn Wilson" <sh***@glassgia nt.com> wrote in message
news:3F******** *******@glassgi ant.com...

Wolfgang Lang wrote:

Hello community!

I am successfully using mysql connections and operations in more than one php file.
But when I want to use this in an included

(required("head er.inc.php"))

php file but nothing happens except an error on
mysql_select.
Has mysql problems from included files or what could be the problem?

with kind regards
Wolfgang L.
I'm not sure I understand the syntax you're using. It should be

something like

this (note there is no "d" on the end of include or require):

include ("header.inc.ph p");
or
require ("header.inc.ph p");

If that's what you have, are you sure you have the path right? The

syntax above

should be used if the include file is in the same directory as the

script you're

including it in. Otherwise, you have to include path info. (i.e.
"../../header.inc.php" or "/home/yourdirectory/header.inc.php" )

Is the file actually being included? If you're not sure, type:

echo "<BR><BR>!!!FOO !!!<BR><BR>";

or similar on a line in the include file.

If that's prints out okay, maybe you should describe the mysql error you're

getting.

Regards,
Shawn

the syntax is ok. the file is also included, because i get use of

functions in that specific file in other php
files.

On my local machine i get:
"2003 Can't connect to MySQL server on 'localhost' (10061)"

An on the sourceforge server i get:
"2002 Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)"

you can see it on http://fsth.sourceforge.net

sorry, did not use the right parameters.
the actual error message is:"1044 Access denied for user:
'f***@sc8-pr-web4-b.sourceforge.n et' to database 'news'"
but witz guestbook and news i can connect.

[Shawn Wilson]

Wolfgang Lang wrote:

"Shawn Wilson" <sh***@glassgia nt.com> wrote in message
news:3F******** *******@glassgi ant.com...

Wolfgang Lang wrote:

Hello community!

I am successfully using mysql connections and operations in more than one php file.
But when I want to use this in an included (required("head er.inc.php")) php file but nothing happens except an error on
mysql_select.
Has mysql problems from included files or what could be the problem?

with kind regards
Wolfgang L.

I'm not sure I understand the syntax you're using. It should be something

like

this (note there is no "d" on the end of include or require):

include ("header.inc.ph p");
or
require ("header.inc.ph p");

If that's what you have, are you sure you have the path right? The syntax

above

should be used if the include file is in the same directory as the script

you're

including it in. Otherwise, you have to include path info. (i.e.
"../../header.inc.php" or "/home/yourdirectory/header.inc.php" )

Is the file actually being included? If you're not sure, type:

echo "<BR><BR>!!!FOO !!!<BR><BR>";

or similar on a line in the include file.

If that's prints out okay, maybe you should describe the mysql error

you're

getting.

Regards,
Shawn

the syntax is ok. the file is also included, because i get use of functions
in that specific file in other php
files.

On my local machine i get:
"2003 Can't connect to MySQL server on 'localhost' (10061)"

An on the sourceforge server i get:
"2002 Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)"

you can see it on http://fsth.sourceforge.net

The error I see is:
1044 Access denied for user: 'f***@sc8-pr-web1-b.sourceforge.n et' to database
'news'

Have you set up that user with the appropriate permissions?

Are you able to connect to mysql on your local machine with other scripts?

Regards,
Shawn
--
Shawn Wilson
sh***@glassgian t.com
http://www.glassgiant.com

[Wolfgang Lang]

"Shawn Wilson" <sh***@glassgia nt.com> wrote in message
news:3F******** *******@glassgi ant.com...

Wolfgang Lang wrote:

"Shawn Wilson" <sh***@glassgia nt.com> wrote in message
news:3F******** *******@glassgi ant.com...

Wolfgang Lang wrote:
>
> Hello community!
>
> I am successfully using mysql connections and operations in more

than one

> php file.
> But when I want to use this in an included

(required("head er.inc.php")) php

> file but nothing happens except an error on
> mysql_select.
> Has mysql problems from included files or what could be the problem?
>
> with kind regards
> Wolfgang L.

I'm not sure I understand the syntax you're using. It should be

something like

this (note there is no "d" on the end of include or require):

include ("header.inc.ph p");
or
require ("header.inc.ph p");

If that's what you have, are you sure you have the path right? The

syntax above

should be used if the include file is in the same directory as the

script you're

including it in. Otherwise, you have to include path info. (i.e.
"../../header.inc.php" or "/home/yourdirectory/header.inc.php" )

Is the file actually being included? If you're not sure, type:

echo "<BR><BR>!!!FOO !!!<BR><BR>";

or similar on a line in the include file.

If that's prints out okay, maybe you should describe the mysql error you're

getting.

Regards,
Shawn

the syntax is ok. the file is also included, because i get use of functions in that specific file in other php
files.

On my local machine i get:
"2003 Can't connect to MySQL server on 'localhost' (10061)"

An on the sourceforge server i get:
"2002 Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)"

you can see it on http://fsth.sourceforge.net

The error I see is:
1044 Access denied for user: 'f***@sc8-pr-web1-b.sourceforge.n et' to

database 'news'

Have you set up that user with the appropriate permissions?

Are you able to connect to mysql on your local machine with other scripts?

Regards,
Shawn

yes, i connect to the same database and table on news.php with the same
user/pass settings

[Agelmar]

Wolfgang Lang wrote:

Hello community!

I am successfully using mysql connections and operations in more than
one php file.
But when I want to use this in an included
(required("head er.inc.php")) php file but nothing happens except an
error on
mysql_select.
Has mysql problems from included files or what could be the problem?

with kind regards
Wolfgang L.

For connections inside of an included file, make sure you do something like
$MySQL_Link = mysql_connect(. ...);

and then in the other files, you do
mysql_query(... ., $MySQL_Link);

if you leave off the handle for the database connections, you could have
problems.

[Wolfgang Lang]

"Agelmar" <if**********@c omcast.net> wrote in message
news:bs******** ***@ID-30799.news.uni-berlin.de...

Wolfgang Lang wrote:

Hello community!

I am successfully using mysql connections and operations in more than
one php file.
But when I want to use this in an included
(required("head er.inc.php")) php file but nothing happens except an
error on
mysql_select.
Has mysql problems from included files or what could be the problem?

with kind regards
Wolfgang L.
For connections inside of an included file, make sure you do something

like $MySQL_Link = mysql_connect(. ...);

and then in the other files, you do
mysql_query(... ., $MySQL_Link);

if you leave off the handle for the database connections, you could have
problems.

but in the php files and the included file i use separate mysql
connection/handles.
i always connect, make my select,... and then close the connection.
could this be a problem? should i use one connection for all queries?

[Agelmar]

Wolfgang Lang wrote:

"Agelmar" <if**********@c omcast.net> wrote in message
news:bs******** ***@ID-30799.news.uni-berlin.de...

Wolfgang Lang wrote:

Hello community!

I am successfully using mysql connections and operations in more
than one php file.
But when I want to use this in an included
(required("head er.inc.php")) php file but nothing happens except an
error on
mysql_select.
Has mysql problems from included files or what could be the problem?

with kind regards
Wolfgang L.

For connections inside of an included file, make sure you do
something like $MySQL_Link = mysql_connect(. ...);

and then in the other files, you do
mysql_query(... ., $MySQL_Link);

if you leave off the handle for the database connections, you could
have problems.

but in the php files and the included file i use separate mysql
connection/handles.
i always connect, make my select,... and then close the connection.
could this be a problem? should i use one connection for all queries?

It's certainly easier to just use one connection for all queries. Less work
on both servers, and less prone to errors (forgetting to re-open one,
mis-typing something somewhere etc.)