this is the query

SELECT 
                        members.memberID,
                        members.salutation,
                        members.firstName,
                        members.middleName,
                        members.lastName,
                        members.suffix,
                        members.company,

                        addresses.address1,
                        addresses.address2,
                        addresses.city,
                        addresses.state,
                        addresses.postalCode,
                        addresses.country,
                        addresses.memberID,

                        email.email,
                        email.memberID,

                        phonenumbers.phoneNumber, 
                        phonenumbers.memberId,

                        subscriptions.year,
                        subscriptions.memberID
                    FROM 
                        members,
                        addresses,
                        email,
                        phonenumbers,
                        subscriptions
                    WHERE
                        subscriptions.year = '%s'
                            AND
                        subscriptions.memberID = members.memberID
                            AND
                        subscriptions.memberID = addresses.memberID
                            AND
                        subscriptions.memberID = email.memberID
                            AND
                        subscriptions.memberID = phonenumbers.memberID
                    ORDER BY 
                        members.lastName,
                        members.firstName,
                        members.company
LIMIT 0, 10

my problem is its a huge query so Im trying to limit it to so many at a time... its supposed to have over 5000 results... anyway the only limit that works is limit 0, 10 if you do anything else 5, 10 it doesnt work 0, 50 doesnt work... only 0, 10 works...

and when I do 0, 10 the query returns blake firstName, middleName, lastName, and a few others... and when I do a print_r() on the $result it shows them blank as well and there is most def data in the database and there is also no typos for that...