justravis Posted November 15, 2003 Share Posted November 15, 2003 i hav 2 selectboxes for month & yr. [php:1:7dde7365b6]<?php $grad_date= \"$grad_yr-$grad_mo-00\"; $studquery=\"INSERT INTO student (`first`, `last`, `nick`, `ss`, `pass`, `phone`, `email`, `emph_id`, `units_left`, `grad_date`) values (\'$first\', \'$last\', \'$nick\', \'$ss\', \'$pass\', \'$phone\', \'$email\', \'$emphasis\', \'$units_left\', \'$grad_date\')\"; ?>[/php:1:7dde7365b6] All the other fields insert except the grad_date just ends up 0000-00-00. ANY IDEAS WOULD BE GREATLY APPRECIATED!!!! Quote Link to comment https://forums.phpfreaks.com/topic/1369-cant-insert-into-mysql-date-yyyy-mm-dd-field/ Share on other sites More sharing options...
Barand Posted November 15, 2003 Share Posted November 15, 2003 Assume they are all on the 1st of the month and not the 0th. Quote Link to comment https://forums.phpfreaks.com/topic/1369-cant-insert-into-mysql-date-yyyy-mm-dd-field/#findComment-4534 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.