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, Link to comment https://forums.phpfreaks.com/topic/36358-cant-use-where-clause-with-limit/ 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. Link to comment https://forums.phpfreaks.com/topic/36358-cant-use-where-clause-with-limit/#findComment-172958 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.