Wednesday, 15 April 2015

php - Only show unvisited links -


Every time someone clicks on a link on my website, then I will link the link's ID and the user's username In this one who clicked it, a table named Out_log, I have another table called the link

  $ query = "0, 10" from the range of ID DESC to select link ";   

I see a way to show IDs that are not clicked by users

Something like this question should work.

  SELECT * links from WHERE id is not (SELECT link_id from out_log WHERE user_id = & lt; user_id & gt;) ORDER ID DESC LIMIT 0, 10   < / Div> 

No comments:

Post a Comment