Reputation: 1 Apprentice
- Active Members
- Active Posts:
- 73 (0.06 per day)
- 01-October 10
- Profile Views:
- Last Active:
- Sep 19 2013 01:07 PM
- OS Preference:
- Favorite Browser:
- Favorite Processor:
- Who Cares
- Favorite Gaming Platform:
- Your Car:
- Who Cares
- Dream Kudos:
Posts I've Made
Posted 23 Jan 2013Maybe a Cron job?
Yes I red about that. Is there another way to do it? Something that does not rely on another program.
Posted 5 Jan 2013
Posted 4 Jan 2013Thank you for your answers!
The $_POST['square'] does here hold the value 13, which is the name of a collum in the database.
This suggests a serious flaw in your database design. Both that you are having to use a variable as the column name, and that this column name is a number, would indicate that you are violating the first normal form. (The first "rule" of relational database design.)
If you show us your complete database design, we could point out ways to fix that. Judging by that single query you posted, I would think that you'd need at least four tables to accomplish what you are trying to do there. One table for the games, one for a list of users, one to link those two, and a fourth to store the various sign values for each game.
The reason that I tried to use the column name as a variable was to minimize the amount og code I had to write. I could simply just make a if-statement with 9 different outcomes. The reason as for why I am using numbers as column names is because they represent x and y values for a 3x3 grid. Right now I have 2 tables, one for the game and one for the user data. I don't think I would need any more tables than that. Any way, thank you all for the help. I will try to fix the query now and come back to you if I run in to any more problems along the way.
Posted 2 Dec 2012It's not "kind of stupid" - it's really very stupid. We really need to do something about it people.
Thank you for taking the time to write to us about it tim9009. I for one was not aware that DIC has one of its main if not main facility, THAT much broken.
No problem, i'm just happy to help.
Posted 2 Dec 2012thatís not strange, thatís called case-sensitivity. .onreadystatechange is different from .onReadyStateChange (etc.).
Yes I know that, I'm just saying that it is strange that dreamincode changes what I wrote to all lower case letters. That is kind of stupid as this problem would have been solved much faster had it not been changed.
- Member Title:
- D.I.C Head
- Age Unknown
- Birthday Unknown
- Programming, Design and Music
- Programming Languages:
tim9009 hasn't added any friends yet.