Jump to content

sql exclude script?


champoi

Recommended Posts

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.