Thanks Guys,
For some reason LIMIT seems to have a bug. LIMIT 0,20 works fine and gived me the first 20 records...but if I use LIMIT 10,20 I will recieve records 10 - 29. I know this is nothing to do with my perl script as it happens when I run the command from the MySQL prompt.
What version...