Trouble with Storing Time in Table DB & Retrieving Output

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,
Ellie

SCREENSHOT: http://siteformybiz.com/1.jpeg

SCREENSHOT: http://siteformybiz.com/2.jpeg

(Sorry to post links like that - but having trouble with posting/uploader).

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.

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

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 :)

Okay. Please update us here for the results. We'll make sure to help you accomplish that to your form.

Thanks