LogFAQs > #975745089

LurkerFAQs, Active DB, DB1, DB2, DB3, DB4, DB5, DB6, DB7, DB8, DB9, DB10, DB11, Database 12 ( 11.2023-? ), Clear
Topic List
Page List: 1
TopicSave My Hisuian Form: Day 23 (RULE CHANGE) [smhf] [bot]
Grimlyn
08/30/23 1:24:20 AM
#40:


I mean in the code I left out a needed S in the query because I added a JOIN statement between the saves table and the contests table

I typically alias the query as
SELECT ___ FROM saves S
LEFT JOIN contests C ON S.contest_id=C.contest_id

essentially I added that second line without declaring that S on the first line so bot was like "wtf is S.contest_id"

before I was just using the who does command on the current contest, so when I changed it so you can specific contests I added the second line

---
http://gmun.moe/ffcc
GuessMyUserName's account's very own account!
... Copied to Clipboard!
Topic List
Page List: 1