[Merovingian]

Yaooo
Ive recently made a news script from scratch but I encountered a wee little problem:

PHP Code:

if($r)

{

$today = date("F j, Y, g:i a");                        

$sql = "INSERT INTO XXX( `entry_date` , `username` , `entry_title` , `entry`)";

$sql .= "VALUES (' ". $today . " ' , ' " . $user . " ' ,'  " . $title. " ' ,'  " . $entry . " ')";

$ret = mysql_query($sql);

if(!($r))

{

printf(" An Error occured...");

print mysql_error();

} 

.
Now the problem with the script is that it doesnt seem to input the actual date and time unto the row thats in MySQL ergo giving me nothing but0000-00-00 00:00 when it is viewed.
But weird it is that i have another similar script that has the same line but is actually inserting it into the row of where it should be situated in.

can somone help me with this one ?
Is there a better way to actually input the proper date and time into MySQL than what I am already utilizing?

Thank you all for your counsel.


}

[Bonzo]

I am new to php but I have noticed that you have at the top of your code if ($r) should this be something like if ($r == 1)

I am using this in one of my uploads - the variables are passed in a form.

$result2 = mysql_query ("INSERT INTO photos (image, date, person, text )
VALUES ('$image', '$date', '$person', '$text' )");


Anthony

[AvanteGuard]

Personally I hate moving times between php and sql format. Timestamps seem to work the best for me! But if you want to do it your date string should look like:

PHP Code:

$today = date("Y-m-d H:i:s"); 

that would return 2004-04-04 13:12:46 (the format I believe your date is in.)

oh and Bonzo, if($r) means that if($r!=false) (If $r is not equal to false, 0 or null)

[Bonzo]

Thanks for the info AvanteGuard its nice to learn something new.

Anthony

[Merovingian]

Got it to work I had the wrong date code for datetime!
Ergo everything was not functioning due to that minuscule error in $today.
But now it is thanks guys.