tim9009's Profile User Rating: -----

Reputation: 1 Apprentice
Active Members
Active Posts:
73 (0.05 per day)
01-October 10
Profile Views:
Last Active:
User is offline Sep 19 2013 01:07 PM

Previous Fields

OS Preference:
Favorite Browser:
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Your Car:
Who Cares
Dream Kudos:
Icon   tim9009 has not set their status

Posts I've Made

  1. In Topic: Sending a automatically mail at a specific time.

    Posted 23 Jan 2013

    View Postmodi123_1, on 23 January 2013 - 06:54 PM, said:

    Maybe a Cron job?

    Yes I red about that. Is there another way to do it? Something that does not rely on another program.
  2. In Topic: SQL query failing.

    Posted 5 Jan 2013

    View PostDormilich, on 05 January 2013 - 12:15 PM, said:

    that sounds like you want to code a game of TicTacToe.

    Yes that is what I am making, and I am 95% finished so I won't be changing much for now, but thank you a lot for the links any way. Allways good to learn other ways to write the code.

  3. In Topic: SQL query failing.

    Posted 4 Jan 2013

    Thank you for your answers!

    View PostAtli, on 04 January 2013 - 06:12 PM, said:

    View Posttim9009, on 04 January 2013 - 04:47 PM, said:

    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.

My Information

Member Title:
D.I.C Head
Age Unknown
Birthday Unknown
Programming, Design and Music
Programming Languages:
C++, DarkBASIC (pro), JavaScript, PHP, SQL

Contact Information



tim9009 hasn't added any friends yet.


tim9009 has no profile comments yet. Why not say hello?