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 :))