Gyohdon Posted December 27, 2010 Share Posted December 27, 2010 I have added a `Date` column to my table (DATE NOT NULL) and everytime something is inserted, 'CURDATE()' will be inserted.However, now that I've done that, it doesn't store any other value (except for the ID, but that's on auto_increment).Should I store dates in another table? Link to comment Share on other sites More sharing options...
thescientist Posted December 27, 2010 Share Posted December 27, 2010 I'm confused. Your first line say's your INSERTS work fine, but then you say value's aren't stored anymore? Is that with trying to do an UPDATE? Link to comment Share on other sites More sharing options...
Gyohdon Posted December 27, 2010 Author Share Posted December 27, 2010 Never mind.I forgot a ' * ' in my SELECT query, but for some odd reason didn't receive an error. Link to comment Share on other sites More sharing options...
boen_robot Posted December 28, 2010 Share Posted December 28, 2010 Because you are allowed to perform select statements which return en empty result set... yeah, sort of pointless, I know. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.