MySQL - Not able to enter 0 in the database ?

Discussion in 'MySQL' started by poseidon, Nov 23, 2007.

Thread Status:
Not open for further replies.
0
  1. #1
    Well I am trying to enter 0 into the table(from front end) but it is giving error. Surprisingly, I am able to enter any other value.

    The field's type is INT and I tried all combinations of making it NULL and not NULL. I have also made the datatype Float as well varchar but still, it is not accepting 0. WHenever i enter any other value than 0, it easily accepts it.

    I know what what is going on but the problem is, I don't know how to fix it ? I am sure there will be few others who might have faced the same problem.
     
    poseidon, Nov 23, 2007 IP
  2. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #2
    can u try to run a add new record or update query to add "0"

    Regards

    Alex
     
    kmap, Nov 23, 2007 IP
  3. poseidon

    poseidon Banned

    Messages:
    4,356
    Likes Received:
    246
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Problem Solved, there was wrong php code :) I fixed it.
     
    poseidon, Nov 23, 2007 IP
Thread Status:
Not open for further replies.