Hi. my guests see the default 25 posts per page.... but when users log in, they only see 10 per page....is there an SQL command that will set the posts per page for the users to be 25? thanks

you can try

UPDATE w3t_Users
SET U_PostsPer = '25'

for everyone and

UPDATE w3t_Users
SET U_PostsPer = '25'
WHERE U_Username = 'nameofperson'

for a certain person

k thanks scroungr, will try that