Looping back on this as I still haven't fixed this problem.

I have done a bit more work and found out more.

I can connect to every table in my db. In fact I can UPDATE and INSERT into the table in question - but every SELECT statement fails silently. And to make things more interesting all the selects work fine if I access the db through a different mechanism, ie phpMyAdmin.

Any ideas?