Posted: Mon Jan 05, 2004 2:51 pm
This is getting interesting!
Thanks so much again for keeping on me with this.
You say:
(I'm going to try it anyway but I thought I'd get your opinion. I wonder if this could be my problem. My only concern is that it works on some peoples and not on others (all using the same website/server).
Did my error message help at all btw?
Thanks again
Rob
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