in reply to [SOLVED] Need advice how to diagnose the problem when syntax using MAX() is correct according to MySQL monitor, but errors out in DBI

Basically the code that fails is this:
Basically? Ok, so your first task is to determine how that code differs from the actual failing code. Can you come up with a complete script demonstrating the problem? And verify you are connecting to the same server and database when using your monitor console.
  • Comment on Re: Need advice how to diagnose the problem when syntax using MAX() is correct according to MySQL monitor, but errors out in DBI