[SOLVED] Insert problems

[affordit]

I am doing something wrong here but I caan't see it can someone help?

The code below is not inserting for some reason. Was working OK till I included $ds?

 

<?php

$name="Patrick";

$st = date("m/d/Y",strtotime("+30 days"));

$ds = date("m/d/Y",strtotime(""));

include("k_falls_dbinfo2.inc.php");

mysql_connect(mysql,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

 

$query = "INSERT INTO `test` (`name`, 'expire_date','date_submitted') VALUES ('$name','$st','$ds')";

mysql_query($query);

mysql_close();

echo "All Done. <br> Your Subscription will expire: ";

 

echo $st;

echo $ds;

?>

[revraz]

mysql_query($query) or die (mysql_error());

 

What is the field type for your date_submitted column in your DB?

 

What purpose does strtotime serve here

$ds = date("m/d/Y",strtotime(""));

[affordit]

STARTED WITH THIS:

$query = "INSERT INTO `test` (`name`, 'expire_date','date_submitted') VALUES ('$name','$st',NOW())";

COULD NOT GET IT TO INSERT

 

SO TRIED THIS:

$query = "INSERT INTO `test` (`name`, 'expire_date','date_submitted') VALUES ('$name','$st','$ds')";

 

ALONG WITH THIS LINE:

$ds = date("m/d/Y",strtotime(""));

 

[revraz]

And what is the error when you add the part I entered above.

 

 

 

What is the field type for your date_submitted column in your DB?

 

[affordit]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''expire_date','date_submitted') VALUES ('Patrick','02/24/2008','

[rhodesa]

Try this: (you have single quotes around the field names when you need back ticks)

 

<?php
$name="Patrick";
$st = date("m/d/Y",strtotime("+30 days"));
$ds = date("m/d/Y");
include("k_falls_dbinfo2.inc.php");
mysql_connect(mysql,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO `test` (`name`,`expire_date`,`date_submitted`) VALUES ('$name','$st','$ds')";
mysql_query($query) or die("Query failed");
mysql_close();
echo "All Done. Your Subscription will expire: ";

echo $st;
echo $ds;
?>

[affordit]

OK that got it to insert but 000 values in the expire_date and date_submitted fields?

[revraz]

Sounds right, echo $st and $ds to see what they contain.

[affordit]

They are being echoed and they show properly but when I fetch them back with a select query they both come back as 0000-00-00 00:00:00

[rhodesa]

try:

 

<?php
$st = date("Y-m-d",strtotime("+30 days"));
$ds = date("Y-m-d");
?>

 

And...you still haven't told us the data type you have set in your table for the two fields

[affordit]

sORRY ABOUT THAT Both are set to DATETIME

[revraz]

Then you need to INSERT based on the DATETIME format, as Rhodesa just did above.

 

sORRY ABOUT THAT Both are set to DATETIME

[affordit]

DOH Thanks all got it appreciate the help guys