Previously i was using a different coding before which worked fine except that due to the way LIMIT works, it was limiting everything that was being queried and not the bit i wanted to. So someone mad ...