Hey guys I created a site that host contest. I need to compare which contest my users have not applied to and display them using pagination.
I have to tables joined_contest which hold a list of contest my users apply to and available_contest which hold the list of contest available.
I need a query that can compare the contest my user has already joined and the contest they have not joined yet.
my example :
[block]$query="Select available_contest.title FROM available_contest INNER JOIN joined_contest ON available_contest.title != joined_contest.title WHERE available_contest.status='ON'";[/block]
+++The query above only gets me about 2 contest :
1. Basically I'm asking(trying) to compare available_contest to joined_contest
and get the contest that my user has not joined.
Again I need a query that will compare one table1 to table2 and pull from table1 that is not in table two.
My pagination will use this same query to output the results, thanks.