Jakob,
See if this does what you're looking for.
// returns a string with the current mySQL version connecting handled by
$dbh.
$mysqlver = pos(mysql_fetch_row(mysql_query("SELECT VERSION()",$dbh)));
--
Aaron
----- Original Message -----
From: "Jakob" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 2:56 PM
Subject: [PHP] how to find out the mysql version from php?
>
> several people seem the have the "case sensitivity problem"
> regarding different mysql versions - see this extract from
> the mysql manual:
>
> "
> Prior to MySQL Version 3.23.4, REGEXP is case sensitive, and the previous
query
> will return no rows. To match either lowercase or uppercase `b', use this
query
> instead:
>
> mysql> SELECT * FROM pet WHERE name REGEXP "^[bB]";
>
> From MySQL 3.23.4 on, to force a REGEXP comparison to be case sensitive,
use
> the BINARY keyword to make one of the strings a binary string. This query
will
> match only lowercase `b' at the beginning of a name:
>
> mysql> SELECT * FROM pet WHERE name REGEXP BINARY "^b";
> "
>
> is there a way to find out _programmatically_ which version of mysql is
running
> (phpinfo() gives some information, but i don't know how this can be
accessed)
> on the server.
>
> thanks in advance,
> Jakob.
>
> PS: please cc me, i am on the very long digest list.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
