zampu Posted June 11, 2007 Share Posted June 11, 2007 when i use $query=mysql_query("SELECT link FROM users WHERE clicked='no' ORDER BY points ASC LIMIT 0, 10"); it pulls all of them (not just the ones who have the value clicked='no') when i use $query=mysql_query("SELECT link FROM users WHERE clicked='no'"); it DOES only pull the ones where clicked='no' but i need the rest of the query. Any help? Quote Link to comment Share on other sites More sharing options...
redarrow Posted June 11, 2007 Share Posted June 11, 2007 try with no gap 0,10 ok. $query=mysql_query("SELECT link FROM users WHERE clicked='no' ORDER BY points ASC LIMIT 0,10"); Quote Link to comment Share on other sites More sharing options...
zampu Posted June 11, 2007 Author Share Posted June 11, 2007 YAY thanks man. 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.