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? 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.. 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 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. Link to comment https://forums.phpfreaks.com/topic/140789-sql-exclude-script/#findComment-736977 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.