Hello Frankfrank
I am a PHP/MySQL developer and have completed many projects on this site that involve exactly what you need: PHP extracting and returning data from MySQL. I can build this PHP script for you fairly quickly (less than a day, depending on complexity of the query), including all coding to prevent SQL injection attacks, etc. (I'm also assuming that the PHP script will have some kind of authentication mechanism).
I don't have a VB6 license, but I can give you a VBA code example on how to call the script, or a C#.Net example to do the same.
Best regards
Brent