SyncMaster Posted February 5, 2016 Group: Members Topic Count: 53 Topics Per Day: 0.01 Content Count: 123 Reputation: 38 Joined: 07/15/13 Last Seen: April 16 Share Posted February 5, 2016 I believe i'm doing something wrong in that piece of the script, I would like to know how it should be... `dias_offline` >= '10' IN (SELECT `dias_offline` FROM `login`)"; Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted February 5, 2016 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2370 Joined: 10/28/11 Last Seen: 21 hours ago Share Posted February 5, 2016 these kind of error message is pretty self explained. the column `dias_offline` doesn't exist in your `login` table. what to do to fix it ? add the missing column `dias_offline` Quote Link to comment Share on other sites More sharing options...
0 SyncMaster Posted February 5, 2016 Group: Members Topic Count: 53 Topics Per Day: 0.01 Content Count: 123 Reputation: 38 Joined: 07/15/13 Last Seen: April 16 Author Share Posted February 5, 2016 (edited) these kind of error message is pretty self explained. the column `dias_offline` doesn't exist in your `login` table. what to do to fix it ? add the missing column `dias_offline` Yes, it's self explained, but the error isn't because of the column. The "Where Clause" isn't right and not indicating corretly the login folder due to any mistake that I made when I was building the bolded part on the post. The previosly command without being underlined by red with the same column are working and the column 'dias_offline' already added. I need to correct sintax that replace the bold part to make it correctly search the column "dias_offline" inside "login" `dias_offline` >= '10' IN (SELECT `dias_offline` FROM `login`)"; Edited February 5, 2016 by SyncMaster Quote Link to comment Share on other sites More sharing options...
Question
SyncMaster
I believe i'm doing something wrong in that piece of the script, I would like to know how it should be...
`dias_offline` >= '10' IN (SELECT `dias_offline` FROM `login`)";
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.