[Resolved] [Resolved] How to get the MySql version from a php script

[sarahk]

I'm writing a utility for GPL and a query I want to run is only available on MySql 4.1. I'll leave it in for those people with it because it's more efficient but I'll need something else for the people on earlier versions (like me!). So I need to know which code to run ...

How, within php do I query the database to get it's version?

[jerdo]

http://www.php.net/manual/en/function.mysql-get-server-info.php

[sarahk]

Thanks Jerdo, I'd searched the mysql documentation and I'd searched the threads here but had forgotten the ever reliable php.net.

[jerdo]

Not a problem, I would've posted the command from that page, but I was feeling lazy and copying the link was faster.