My Sql query problem?

Question

Hi,

Heres my query:

$query = "INSERT INTO tags (tag_id, tagger_id, location_name) VALUES ('$fn', '$ln', '$e')";

My problem is that it only works when tag_id, tagger_id, location_name are in the database as the first three columns, what am I doing wrong?

Answer 1

You are naming the columns so that shouldn't be your problem. What language and database are you using? Try using this query directly with the sql tool outside of the language you are using.

Answer 2

Try to add "`" for each field name:

$query = "INSERT INTO tags(`tag_id`, `tagger_id`, `location_name`) VALUES ('$fn', '$ln', '$e')";

Answer 3

Your syntax is, as usual, wrong.
In the time it takes you to ask questions and wait for answers, you would have learnt HTML, java, PhP and MySQL properly.