Topic List | Page List: 1 |
---|---|
Topic | Save 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 |