Matthew1980 - 11:31 am on Aug 13, 2010 (gmt 0)

Hi there LifeInAsia,

Yes, I have mysql query browers running, which is more strict than phpmyadmin, and is easier to get working ;)

Apologies though, at some ungodly hour this morning, I cracked the issue, after extensive reading of the mysql website for the ADO topics, there is an obscure link/paragraph that pointed me to a sollution. With VB6->Mysql you have to instruct the query to 'allow' more than one row to be returned, else the RecordCount/RecordSet object will always return -1, which means that the server hasn't received the instruction to say 'Show all records'. So I amended my object to: ComboQuery.adUseClient before the query was exectued, and now the result returned is correct, all 4 rows are there. Woo!

So thanks for your replies/help, again I know this is a webmaster forum, but I couldn't see the harm of posting.

Cheers from a very chuffed VB6 programmer! (I really had better migrate to .NET now too :))
MRb