Show MySQL version.

[XMG-Eric]

Is there a way to show the version of MySQL your running? like phpversion()?

[r937]

run this query:

select version()

[XMG-Eric]

run this query:

select version()

hmm... like this?

define ('DB_USER', 'myname');
define ('DB_PASSWORD', 'pass');
define ('DB_HOST', 'localhost');
define ('DB_NAME', 'mydb');

// Make the connnection and then select the database.
$dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to MySQL: ' . mysql_error() );
mysql_select_db (DB_NAME) OR die ('Could not select the database: ' . mysql_error() );
$query="select version()";
$result=mysql_query($query);
mysql_close();

[jaswinder_rana]

yes
and one more thing when you do
mysql_query() you should use die() here too. like
mysql_query(die(mysql_error()); to see if query executed successfully or not
just a suggestion

[XMG-Eric]

hmm..i tried the code above and got nothing. is there any other way to acomplish this?

[r937]

do you have phpmyadmin or a similar front end program?

[Chris82]

You can also use mysql_get_server_info to get the version of your MySQL server.

[XMG-Eric]

do you have phpmyadmin or a similar front end program?

Yes, i have phpmyadmin.

[r937]

Yes, i have phpmyadmin.

so, when you run this query --

select version()

what do you get?