-
ellie123Asked on July 4, 2014 at 6:53 PM
Hello -
So, my form is storing my results o my db table. But, when trying to output I am getting "ARRAY" in the field for the the Time.
How do I set this column up in my table so I can work with the output?
I know I don't have my structure setup properly but I'm not sure what to put for the settings (i.e. type, Collation, Attributes, etc.)
I really liked the TimePicker Widget, but again...not sure how to set that up.
Can you give me any help?
Thank you,
EllieSCREENSHOT: http://siteformybiz.com/1.jpeg
SCREENSHOT: http://siteformybiz.com/2.jpeg
(Sorry to post links like that - but having trouble with posting/uploader).
-
jonathanReplied on July 4, 2014 at 7:33 PM
Hi Ellie,
Can you try first knowing the actual variable names and PHP code in the POST submission of the form. Follow the guide here
http://www.jotform.com/answers/answer_display.php?if_id=363070
Check if the result for the Time Field if its "array"
Thanks.
-
ellie123Replied on July 5, 2014 at 8:58 AM
Yes, I'm sorry. I thought I made that clear - the field is the one with the red box around it in my screenshot above.
the field value is showing as "ARRAY" in my table. I am guessing its a few reasons why, one of them being I don't have the structure setup correctly. As you can see I have it as a varchar field. Shouldn't this be something else?
and since it's value in my table is showing as ARRAY Do I need add'l columns or anything?
The name of the field is "plsenter23"
thank you
-
ellie123Replied on July 5, 2014 at 9:10 AM
I think this is what I'm looking for:
$datetime = $_POST['DateTime']['2'] ."-". $_POST['DateTime']['0'] ."-". $_POST['DateTime']['1'] ." ". $_POST['DateTime']['3'] .":". $_POST['DateTime']['4'];
.....STANDBY :)
-
Welvin Support Team LeadReplied on July 5, 2014 at 2:21 PM
Okay. Please update us here for the results. We'll make sure to help you accomplish that to your form.
Thanks