MySQL Forums
Forum List  »  PHP

MySQL connector for PHP - version problems
Posted by: Freddy Bruggeman
Date: January 25, 2006 06:06AM

Hello,

I recently installed PHP5/MySQL5 on my PHP4/MySQL4 system (IIS, Win2k3). So far so good, everything works. phpinfo() reports version5 with the mysql and mysqli version 5 dll's.

However when I call mysqli_query("select @@version") in my script it reports 4.1.10a-nt, but on the same script phpinfo() reports 5.0.18...

Because of above reason calling this:
mysqli_multi_query("select helloworld()")
Gives the error "You have an error in your SQL syntax (..) near '()' at line 1"
Other queries that would work with MySQL4 too, work in above example, though.

Calling above query in a direct connection with the server of course works.

Somewhere PHP5 is using the old PHP4 extensions (PHP4 is still installed - PHP5 files can be run by naming the file .php5). Going to the php5\ext folder > properties of the dll's gives me the correct version 5 DLL's. PHP4 does not have those DLL's because back in PHP4 those were built-in.

I tried rebooting the server, but @@version still reports 4.1 in my php5 files. Any suggestions to fix this problem?

Options: ReplyQuote


Subject
Written By
Posted
MySQL connector for PHP - version problems
January 25, 2006 06:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.