I've learned that whenever I get a syntax error for line X (9 in your example), the error is usually at the end of the previous line...8.
Line 8: display = 0
compare that to line 7 since it's basically the same, and you can see it's missing a comma. I don't think you need a comma after "rankorder = 1" though. Commas are separating all the values...not the WHERE statement.
|