Inserting Date?

[furious5]

I'm not sure if I using the correct function.

Basically I am wanting to create a date and insert this in to an SQL statement, with a y-m-d format.

I tried using this: $today = date("Y-j-n");

It prints fine on screen but doesn't insert in to the db any ideas?

This is the sql I am using:

$sql = "INSERT INTO JOB (jobid, date, title, description, location, skills, salary, industry) VALUES ('$jobid', '$today', '$title', '$description', '$location', '$skills', '$salary', '$industry')";

[dbchip2000]

You have date("Y-j-n"), but the 'n' is the month, without leading zeros. Try date("Y-m-d") and it should work

[DigitalExpl0it]

try somthing like this

<?
$connect = mysql_connect($hostname, $user_name, $user_pass) or die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
$db = mysql_select_db($database, $connect) or die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
$sql = "INSERT INTO JOB SET
jobid='".$jobid."',
date='".$today."',
title='".$title."',
description='".$description."',
location='".$location."',
skills='".$skills."',
salary='".$salary."',
industry='".$industry."'";
$sql_result = mysql_query($sql, $connect) or die ("<b><center>".mysql_errno().": ".mysql_error()."</b></center>\n");
mysql_close($connect);
?>

[furious5]

Ah yes, didn't spot that one!

Cheers