You say:
Would it therefore be possible to mix them together in the one INSERT line like this?INSERT INTO mytable (year, month, day) VALUES ($year, $month, $day)
assuming that year, month and day are integer fields.
If they are varchars, then you'd have to go:
INSERT INTO mytable (year, month, day) VALUES ('$year', '$month', '$day')
Code: Select all
INSERT INTO mytable (year, month, day, textfield1, texfield2) VALUES ($year, $month, $day, '$text1', '$text2')Did my error message help at all btw?
Thanks again
Rob