2. PHPRunner General questions
  3. Date Field demands entry
This topic is locked

Date Field demands entry

 		1/24/2008 11:14:01
PHPRunner General questions
bbarker author

I have 5 date fields on a single page. All in the same table.
When I fill one in and try to save, it prompts me to fill in the remaining four dates.
The "required" button is unchecked for all of them.
Is this a code issue or does it have something to do with the way the field was registered in MySQL?
A
 		alang 1/24/2008

Can you use something like SQLyog to look at the database and see if "Not Null" is checked for these fields (under Alter Table)
bbarker author 1/24/2008

Here's what it looks like:
FIELD TYPE NULL DEFAULT

date1 int(8) YES NULL
And then this repeats four more times... date2 - date5
bbarker author 1/25/2008

Nevermind...
I gave up on trying to resolve it... I tried multiple combinations using the PHP manual as a guide. Unfortunately it has lots of details, but not many useful examples.
Broke it into a new table with a single date field.
----END------