Mysql_query error PHP

[danoussh]

Hi everyone, thanks for having this type of forum. Hope you will be able to help me

So here is my script, the idea is basic, complete a html form and subtmit the data to php script which will send the data in a SQL table. It also uploads pictures.

Now the script isn't perfect yet, it still needs some conditions and stuff for all situation.
But for now the important part, i need to find out why i cannot store data in the database.

Systeme Config:

• WampServer Version 2.0
• Apache 2.2.11
• PHP 5.3.0, Default configs
• MySQL 5.1.36

There was something in my script that makes your website go nuts (Internal Error+ additional 404) so i pasted it on PasteBin, i hope this is ok with everyone.

http://pastebin.com/u4dy7Sr5

Thanks in advance.
Danoussh

[danoussh]

Forgot to port the error:

http://pastebin.com/riS2sSgh

[RoseKnight]

MYSQL likes it when you surround table names and key names with the tilde `

so try changing 'release' to `release`and see what happens

[danoussh]

Thank you RoseKnight .

But i'm a little surprised, wouldn't it also work not using any tilde ( ` ) or anything else.
Some tutorials don't have this detail.

But i suppose it always better to use it anyway.

Danoussh

[RoseKnight]

I spent around 5 hours while learning MYSQL debugging just to find that out. I have no idea why it it's like that. It's rather annoying, and odd that its not in any tutorials.

[RoseKnight]

as a side note, this ~ is a tilde and this ` is an acute . How did I mix those two up? sorry... (:

[tequilaprince]

It looks like RELEASE is a reserved word in MySQL, I had a similar problem with Date as a fieldname and Drop as a table name (DANGEROUS LOL).  Try if possible adding a tbl or something to the table name in your database and the query...  the ` replies above should act similar to this but if that failed this might work... always worth a shot

[hotnoob]

uhh... i always thought that the "`" was just plain old obvious..

`` is for names
'' is for values
that's how it works.