[SOLVED] SQL Date

[dan2684]

I'm trying to insert data into a table in my databse and it's proving to be more diffucult that it should be!

 

Here is my code:

 

$fromDate = "20-20-2009";
$toDate = "20-20-2009";
$sql = "INSERT INTO shows (from, to, venue, stand, area)
VALUES ('$fromDate', '$toDate', '{$_POST['venue']}', '{$_POST['stand']}', '{$_POST['area']}')";

if(!mysql_query($sql)){
       echo mysql_error();
}

 

It's giving me this error:

 

"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 'from, to, venue, stand, area) VALUES ('20-20-2009'..."

 

Any help would be greatly appreciated!

 

Thanks in advance,

 

Dan

[UnfoX]

Maybe the date format should read 2009-12-20 instead of 20-20-2009, i.e; YYYY-MM-DD instead of yours

[dan2684]

You're absolutely right - it should!! I don't know why I did that...

 

That's not the problem though :-/ !

 

FYI - I've changed it to:

 

$fromDate = "2009-10-20";

$toDate = "2009-10-20";

[dan2684]

Again, I'd really appreciate any suggestions! This is seriously doing my head in...!

[PFMaBiSmAd]

Both from and to are reserved keywords - http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

 

While you can make them work, you should avoid using reserved keywords as column names and the best solution would be to rename those to something else.

 

[dan2684]

PFMaBiSmAd - you are a genius, thank you!

 

I can sleep well now. (It's 00:20 here in London!)

 

Thanks again :-)