patrick@computerbrokers.com.sg wrote:
> Greetings. I am new to PHP and would appreciate any I can get.
>
> I am having a tough time figuring out what is going on with the PHP
> installtion on a W2k server. I have configured PHP (by editing the
> php.ini file) to load the php_mysql.dll, which seems to be loaded
> properly because I can run "php -i" from the command prompt and see a
> section with mysql info as follows:
>
> -----------------------------------------------------------------------------------------------
> mysql
>
> MySQL Support => enabled
> Active Persistent Links => 0
> Active Links => 0
> Client API version => 5.0.51a
>
> Directive => Local Value => Master Value
> mysql.allow_persistent => On => On
> mysql.connect_timeout => 60 => 60
> mysql.default_host => no value => no value
> mysql.default_password => no value => no value
> mysql.default_port => no value => no value
> mysql.default_socket => no value => no value
> mysql.default_user => no value => no value
> mysql.max_links => Unlimited => Unlimited
> mysql.max_persistent => Unlimited => Unlimited
> mysql.trace_mode => Off => Off
> -----------------------------------------------------------------------------------------------
>
> PHP also seems to be working fine with IIS because I am able to
> display a .php page on the server that contains the command phpinfo().
> However, if I run any mysql statement in the .php file, (e.g.,
> mysql_connect), the processing seems to just stop at the mysql
> statement, and ignoring everything below it. No error message is
> returned. When I looked at the info generated from phpinfo() on the
> web page, I noticed two things:
> 1. There is no MySQL section (in contrast to the command line result
> above)
> 2. There is a ISAPI section which is not present in the command line
> result.
>
> I guess teh ISAPI thing is normal, but it is the lack of the MySQL
> section that baffles me.
>
> I have also tried usinig php_mysqli.dll instead of php_mysql.dll, and
> I got similar results as above. So, the problem is that the dll is not
> loaded by the web server (i.e., IIS). Any idea what is going on?
> Please .
>
> Many thanks.
>
> Patrick
>

What is the configuration file you're using, as indicated by phpinfo()?
Probably not the one you edited.

Also, enable and display all errors - you should ALWAYS do this in a
development system. That would have shown you the error, probably a
missing function. In your php.ini (the correct one) you need:

error_reporting = E_ALL (or E_ALL | E_STRICT)
display_errors = on

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