champoi Posted January 14, 2009 Share Posted January 14, 2009 uhmmm, i have two tables where in the first has all the information about the user (user_table) and a table that tells if his/her document has been downloaded so if i query from select from user table but im using pages to show the results, how do i exclude those whose documents have been downloaded without affecting the number of results showed in a page? Quote Link to comment https://forums.phpfreaks.com/topic/140789-sql-exclude-script/ Share on other sites More sharing options...
vbnullchar Posted January 14, 2009 Share Posted January 14, 2009 you just need to add a where clause.. Quote Link to comment https://forums.phpfreaks.com/topic/140789-sql-exclude-script/#findComment-736877 Share on other sites More sharing options...
champoi Posted January 14, 2009 Author Share Posted January 14, 2009 you just need to add a where clause.. how? i mean, do you put it in the query? but there are alot of people who are supposed to be excluded. hmmm... i dont really understand what your trying to say... sori Quote Link to comment https://forums.phpfreaks.com/topic/140789-sql-exclude-script/#findComment-736911 Share on other sites More sharing options...
premiso Posted January 14, 2009 Share Posted January 14, 2009 you just need to add a where clause.. how? i mean, do you put it in the query? but there are alot of people who are supposed to be excluded. hmmm... i dont really understand what your trying to say... sori WHERE downloaded = 1 Should exclude them all given that you set a specific variable to tell when their document has been downloaded. Quote Link to comment https://forums.phpfreaks.com/topic/140789-sql-exclude-script/#findComment-736977 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.