Welcome to the Masters of Golf - Golf Pool!
User Name:
Season:
Current Selected Tournament:
Prize Value: $
Score Value: $
Start Date:
Picks due by:
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