centenial Posted January 30, 2007 Share Posted January 30, 2007 Hi,I'm having trouble with an SQL query:SELECT * FROM images WHERE userid = '1' LIMIT 0,16This returns 0 Rows. It should be returning up to 16. When I delete the "WHERE" clause, it returns 16. And when I delete the limit clause it returns every row belonging to user 1. But when I use them together it returns nothing.Can anyone help me? Can't you use a LIMIT clause with a WHERE clause?Thanks, Quote Link to comment Share on other sites More sharing options...
fenway Posted January 30, 2007 Share Posted January 30, 2007 That doesn't seem possible... the syntax looks correct. But try just LIMIT 16. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.