Having some trouble getting a query to work as intended. Bit late so might just be down to me doing something stupid.
I'm getting information from 3 tables and performing a query on them and displaying the details. The part I'm working on now is to do with ratings. I only want to show the data that has a rating over 2.
This works fine, but I'd also like to show ones that havn't been rated.
Is it possible to use OR in the query? I've tried but it always times out and fails to display anything....
Query looks something like this..
"SELECT * FROM 3 tables WHERE match table attributes to link tables and averageRating > 2 ORDER BY'averagescore'DESC LIMIT 6");
the table also has a numberofratings column but if I try adding OR numberofratings = 0 it just times out.
Thanks if you can offer some assistance.