Nope thats absolutely fine. I just wanted a way to return the total number of rows to php for pagination. Perfect thanks very much