MySQL Query

[Dave Thomas]

If I have a table set up like this:

Name | VARCHAR
Email | VARCHAR
Age | TINYINT | NULL (Default: NULL)

And I want the user to enter his or her name, email, and age - but AGE
is optional.

My insert would look something like:

INSERT INTO data (Name, Email, Age) VALUES ('$name', '$email', $age)

This is all good, except if the user doesn't enter an age. Then $age is
an empty variable. I thought that since the table is set up where Age
can be NULL, that this should be fine. But MySQL is giving me an error.
If $age is a number, it is no problem.

Anyway to make it accept $age as an empty variable (and just make it
NULL)? I know I could say:

if (empty($age)) { $age = 0; }

and write it that way, but this is just an example and there are many
more variables that could be empty.

Thanks.

[ZeldorBlat]

Either don't include them in the insert:

insert into data (name, email) values ('$name', '$email')

or make the variable 'null' (literally). Something like:

$age = !empty($age) ? $age : 'null'; //'null' is a string containing
the word 'null'

Then do your query as before.

[Dave Thomas]

ZeldorBlat wrote:

Either don't include them in the insert:

insert into data (name, email) values ('$name', '$email')

or make the variable 'null' (literally). Something like:

$age = !empty($age) ? $age : 'null'; //'null' is a string containing
the word 'null'

Then do your query as before.

I was trying to do it without having to take it out of the query or
assign it NULL... just because there are a large number of variables
that could be empty.

[ZeldorBlat]

If you want the value to be null in the database, then you need some
way of telling MySQL that's what you want. One way is to ommit it from
the insert -- in which case the default value (in this case, null) is
used. The other way is to specify the value as the literal string
'null'.

[ranii4u]

set default value to 0 gor AGE field in structure of database!

[ranii4u]

just dont enter in that field while executing anu INSERT query it will
automatically take that field DEFAULT value NULL without any error.

[ranii4u]

Dont include that field in ur INSERT clause while inserting record it
will take DEFAULT value as NULL as u have specified and set NULL
attribute as 'yes' in ur structure of table and DEFAULT value as 'null'

OR IF,

ur getting values dynamically from user then store all values in
variable and then execute INSERT query even if any value will come null
it will be store in variable and that all variables u used in ur INSERT
query!

[kerul4u]

Just change your insert query with

INSERT INTO data (Name, Email, Age) VALUES ('$name', '$email', '$age')

don't use $age, instead use '$age'

this means when query will be executed it will look like
INSERT INTO data (Name, Email, Age) VALUES ( 'myname', 'email', '' ) if
user is not specifying his/her age.

currently your query looks like this
INSERT INTO data (Name, Email, Age) VALUES ( 'myname', 'email', ) if
user is not specifying his/her age.
and it gives you syntax error.

Do you understan wat i mean?

just do it for all your numeric vaule to be entered.

and recall your PHP fundamentals.

KERUL
['ProDesignZ']

[johan]

On Mon, 29 Aug 2005 11:24:55 -0400, Dave Thomas wrote:

If I have a table set up like this:

Name | VARCHAR
Email | VARCHAR
Age | TINYINT | NULL (Default: NULL)

And I want the user to enter his or her name, email, and age - but AGE
is optional.

My insert would look something like:

INSERT INTO data (Name, Email, Age) VALUES ('$name', '$email', $age)

This is all good, except if the user doesn't enter an age. Then $age is
an empty variable. I thought that since the table is set up where Age
can be NULL, that this should be fine. But MySQL is giving me an error.
If $age is a number, it is no problem.

Anyway to make it accept $age as an empty variable (and just make it
NULL)? I know I could say:

if (empty($age)) { $age = 0; }

and write it that way, but this is just an example and there are many
more variables that could be empty.

Thanks.

BTW, a field containg an AGE has no real value. What will happen net year.
Youd'better take care of the birth day, a fixed data.

Johan

[Kimmo Laine]

"johan" <va*******@hotm ail.com> kirjoitti
viestissä:pa*** *************** **********@hotm ail.com...

On Mon, 29 Aug 2005 11:24:55 -0400, Dave Thomas wrote:

If I have a table set up like this:

Name | VARCHAR
Email | VARCHAR
Age | TINYINT | NULL (Default: NULL)

And I want the user to enter his or her name, email, and age - but AGE
is optional.

My insert would look something like:

INSERT INTO data (Name, Email, Age) VALUES ('$name', '$email', $age)

This is all good, except if the user doesn't enter an age. Then $age is
an empty variable. I thought that since the table is set up where Age
can be NULL, that this should be fine. But MySQL is giving me an error.
If $age is a number, it is no problem.

Anyway to make it accept $age as an empty variable (and just make it
NULL)? I know I could say:

if (empty($age)) { $age = 0; }

and write it that way, but this is just an example and there are many
more variables that could be empty.

Thanks.

BTW, a field containg an AGE has no real value. What will happen net year.
Youd'better take care of the birth day, a fixed data.

Asking age is easier on the user in my opnion, but he could store
(date('Y') - $age) instead, to get the birthyear.

--
SETI @ Home - Donate your cpu's idle time to science.
Further reading at <http://setiweb.ssl.ber keley.edu/>
Kimmo Laine <et************ ****@5P4Mgmail. com>