FUDforum: Database discussions » Zero values in fields

Home » General » Database discussions » Zero values in fields

Show: Today's Messages :: Polls :: Message Navigator

Zero values in fields [message #19820]

Tue, 07 September 2004 00:50

Abraxa

Messages: 72
Registered: August 2004
Location: Germany

Karma: 0

Member

Heya peeps =)

I got a relatively simple problem I guess but I can't figure it out for the life of me.
The deal is that I have zeroes in the fields of a table and when I do a query for those fields the values passed to the PHP variables are empty instead of having a zero in them.

Anyone got an idea about what I can do?

-Abraxa

Report message to a moderator

Re: Zero values in fields [message #19823 is a reply to message #19820]

Tue, 07 September 2004 12:15

dataj1998

Messages: 31
Registered: June 2004
Location: Germany

Karma: 0

Member

It's a difference if you have zeroes (0) or NULL in the field.
What are the types of the fields? Int? Varchar?

If you wanna get the 0 back, they have to be Int or a Varchar where the "string" 0 is in.

Report message to a moderator

Re: Zero values in fields [message #19839 is a reply to message #19820]

Sat, 11 September 2004 01:49

Abraxa

Messages: 72
Registered: August 2004
Location: Germany

Karma: 0

Member

Thanks for the hints! =)

I fiddled around with MySQL and set the field properties of that column to NOT NULL and lowered the length of the length field (at least I think that's all I did, it was a couple days ago).
I just checked again and to my surprise the query does return the zero values now...

Could it have been the NOT NULL option? Sorry, I'm a beginner in MySQL and couldn't find anything about the exact behavior of that option in the MySQL documentation =\

-Soeren

Report message to a moderator

Re: Zero values in fields [message #19842 is a reply to message #19820]

Sun, 12 September 2004 14:32

dataj1998

Messages: 31
Registered: June 2004
Location: Germany

Karma: 0

Member

The solution with the option "NOT NULL" should do the whole job.

If a field is defined to be not null, you should always get a value back. But please be careful: You should set a default value for that field. If you insert a record and leave out a field with the option set and you don't have a default value, your insert will fail.

Report message to a moderator

Re: Zero values in fields [message #19845 is a reply to message #19820]

Sun, 12 September 2004 19:36

Abraxa

Messages: 72
Registered: August 2004
Location: Germany

Karma: 0

Member

Thanks a ton, mate!

People like you are who make coding worthwhile and fun - cause you saved me lots of time figuring out why my INSERTs wouldn't o through cause I unknowingly had the exact problem in my table that you made me aware of =D

-Soeren

Report message to a moderator