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? Link to comment https://forums.phpfreaks.com/topic/55032-solved-arghh-mysql-query-help/ 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"); Link to comment https://forums.phpfreaks.com/topic/55032-solved-arghh-mysql-query-help/#findComment-272044 Share on other sites More sharing options...
zampu Posted June 11, 2007 Author Share Posted June 11, 2007 YAY thanks man. Link to comment https://forums.phpfreaks.com/topic/55032-solved-arghh-mysql-query-help/#findComment-272046 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.