Welcome to the Masters of Golf - Golf Pool!

User Name:
Season:
Current Selected Tournament:

Prize Value: $
Score Value: $
Start Date:

Picks due by:

Here are the picks for the tournament.

There is an error in the following SQL statement:
SELECT p.golferid, picknumber, c.username, golfername, golferlastname, golferfirstname, p.commonpick, p.winnings, p.pickstatus, p.score, p.winningscore, p.defaultpick, p.positionmultiplier FROM Picks p, Golfers g, Contestant c WHERE (p.golferid = g.golferid AND p.contestantid = c.contestantid AND tournamentid = AND c.status = 'A') ORDER BY c.username, picknumber

The error is:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.status = 'A') ORDER BY c.username, pick' at line 17