Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › auto insert date on Store Cart Summary in DB

auto insert date on Store Cart Summary in DB

Thread began 9/14/2009 9:27 am by max14968 | Last modified 9/14/2009 10:13 am by Justin Nemeth | 1158 views | 1 replies |

9/14/2009 9:27 am | #1 max14968

auto insert date on Store Cart Summary in DB

Good Morning,
I've encountered a problem with the function STORE CART SUMMARY IN DATABASE:
I need that a field with type "date" have to insert the actual date "on data submit". I'd like to know which code I have to use to obtain this result,I've tried with php echo (date("y-m-d"); but the type changes automatically from Date to Text and all the fields are regularly recorded in the DB except the field "date".

Thanks in advance
Best regards

9/14/2009 10:13 am | #2 Justin Nemeth

I would recommend using an INTEGER column in your database then inserting <?php echo time(); ?> into that column. That will insert a unix timestamp, which is very easy to format using PHP afterwards. You can use the date() function to format the timestamp however you want.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.