Inserting Current Date

astralweeks

This is my first programming attempt using PHP 4 & mySQL.

I want to insert the current date into a database field called "date" and I get 0000-00-00 instead. Before using $_POST[date] what should I be using to assign the current date to the field "date" ?. I have tried:
$date = date("Ymd");
$date = curdate();

All the other fields are posted to the database just fine (which are being entered into a form first, with the exception of date which I don't want the user to input). Help is appreciated

planetsim

The MySQL Date format is YYYY-MM-DD

SO your going to have to send that same data through like this

$date = date("Y-m-d");

astralweeks

I did try that and various other formats found on the net. Same result. Here's the code affected by this:

$date = date("Y-m-d");
$sql = "INSERT INTO jobs (JOB_TITLE, TYPE, CITY, STATE, JOB_DESC, JOB_SKILLS, DATE, CONTACT)
VALUES ('$POST[job_title]','$POST[type]','$POST[city]','$POST[state]','$POST[job_desc]','$POST[job_skills]',
'$POST[date]','$POST[contact]')";

yelvington

If your database column is of type TIMESTAMP, it will be updated automatically whenever the record is updated.

If your column is of type DATE, you can set it manually:

UPDATE tablename SET date=CURDATE() WHERE somecondition

Note this is SQL, not PHP. You can't call curdate() in PHP, as there is no such function.

yelvington

$sql = "INSERT INTO jobs (JOB_TITLE, TYPE, CITY, STATE, JOB_DESC, JOB_SKILLS, DATE, CONTACT)
VALUES ('$POST[job_title]', '$POST[type]', '$POST[city]'
, '$POST[state]', '$POST[job_desc]', '$POST[job_skills]',
CURDATE(), '$_POST[contact]')";

astralweeks

Worked like a champ ! Thank you so much......