undefined function mysql_connect

[zero]

I know this question has come up before (I found lots of sites discussing
it), but I just can't get it to work.

I have PHP 5.0.4 and MySQL 5.0.16 (community edition). PHP runs under MS
IIS 5.1 (XP Pro SP2). Independently, both PHP and MySQL run fine (other
php pages work fine, and I can access mysql tables through jdbc), but when
I try to query a database from PHP, I get the infamous "Call to undefined
function mysql_connect()" error.

I have uncommented "extension=php_mysql.dll" in php.ini in G:\php\, which
in turn is mentioned in the Windows PATH. I have also made sure the
libmysql.dll and php_mysql.dll files are in the same G:\php\ directory.

What am I missing here?

TIA,
zero

[MeV]

Can't speak to a Windows implementation, but on UNIX, unless you've
built (as in compiled from source) with MySQL support, the mysql
functions aren't part of the php program.

What does the output of phpinfo(); show on a web page or php -i in a
command shell show? If it doesn't list mysql, you'll have to rebuild
it.

[zero]

"MeV" <mi************@gmail.com> wrote in news:1132692640.744248.199900
@g14g2000cwa.googlegroups.com:

Can't speak to a Windows implementation, but on UNIX, unless you've
built (as in compiled from source) with MySQL support, the mysql
functions aren't part of the php program.

What does the output of phpinfo(); show on a web page or php -i in a
command shell show? If it doesn't list mysql, you'll have to rebuild
it.

As I understand it, on windows there is no need to recompile. All
extension libraries are loaded dynamically on startup, by loading the dlls
mentioned in php.ini

At least, that's how I understand it. But obviously I'm missing something,
since it's not loading the mysql library.

[Jerry Stuckle]

zero wrote:

I know this question has come up before (I found lots of sites discussing
it), but I just can't get it to work.

I have PHP 5.0.4 and MySQL 5.0.16 (community edition). PHP runs under MS
IIS 5.1 (XP Pro SP2). Independently, both PHP and MySQL run fine (other
php pages work fine, and I can access mysql tables through jdbc), but when
I try to query a database from PHP, I get the infamous "Call to undefined
function mysql_connect()" error.

I have uncommented "extension=php_mysql.dll" in php.ini in G:\php\, which
in turn is mentioned in the Windows PATH. I have also made sure the
libmysql.dll and php_mysql.dll files are in the same G:\php\ directory.

What am I missing here?

TIA,
zero

You did stop and start the web server, right?

What does phpinfo() show?

Look for the mssql extensions to see if they are loaded.

Also, which php.ini is it using? Is it the one you changed?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[zero]

Jerry Stuckle <js*******@attglobal.net> wrote in
news:et********************@comcast.com:

zero wrote:

I know this question has come up before (I found lots of sites
discussing it), but I just can't get it to work.

I have PHP 5.0.4 and MySQL 5.0.16 (community edition). PHP runs
under MS IIS 5.1 (XP Pro SP2). Independently, both PHP and MySQL run
fine (other php pages work fine, and I can access mysql tables
through jdbc), but when I try to query a database from PHP, I get the
infamous "Call to undefined function mysql_connect()" error.

I have uncommented "extension=php_mysql.dll" in php.ini in G:\php\,
which in turn is mentioned in the Windows PATH. I have also made
sure the libmysql.dll and php_mysql.dll files are in the same G:\php\
directory.

What am I missing here?

TIA,
zero

You did stop and start the web server, right?

What does phpinfo() show?

Look for the mssql extensions to see if they are loaded.

Also, which php.ini is it using? Is it the one you changed?

It was indeed using the wrong php.ini. I changed the path in the registry,
and now it works :-)

Thanks!

[David Haynes]

zero wrote:

I know this question has come up before (I found lots of sites discussing
it), but I just can't get it to work.

I have PHP 5.0.4 and MySQL 5.0.16 (community edition). PHP runs under MS
IIS 5.1 (XP Pro SP2). Independently, both PHP and MySQL run fine (other
php pages work fine, and I can access mysql tables through jdbc), but when
I try to query a database from PHP, I get the infamous "Call to undefined
function mysql_connect()" error.

I have uncommented "extension=php_mysql.dll" in php.ini in G:\php\, which
in turn is mentioned in the Windows PATH. I have also made sure the
libmysql.dll and php_mysql.dll files are in the same G:\php\ directory.

What am I missing here?

TIA,
zero

What do you have extension_dir set to?
It should point to the ext directory (G:\php\ext)

-david-