INSERT SQL statement help...

[mfacer]

Hey,
I've got the following insert sql statement:

INSERT INTO table (ref,EXT_hours,NP_hours,WG_hours) VALUES( '".$_POST['ref']."',".$_POST['EXT_hours'].",".$_POST['NP_hours'].",".$_POST['WG_hours'].")

the problem is when the user enters say only the "ref" and "EXT_hours" it throws an SQL error as there are no values being entered in to NP hours and WG hours.... the SQL looks like

INSERT INTO table (ref,EXT_hours,NP_hours,WG_hours) VALUES( 'test',1,,)

and as there are no numbers being entered it gets an error.... what do you recommend I do? Is there a simple solution?!

[lilleman]

Hi,

You can enclose the values in single-quotes. When doing that, you do not have to worry if the user has entered a number or not.

Yours, Erik.

[mfacer]

would the SQL not think that you are entering a string though? the field is an integer...

[lilleman]

Hi,

In MySQL it doesn't matter if the number is enclosed in quotes.

Yours, Erik.