problem with a mysql-query in php 1

[frag]

i have this query:

$query = "INSERT INTO clanwar (name, tag, typ, datum, ergebnis1, ergebnis2) VALUES (\'$HTTP_POST_VARS["name"]\', \'$HTTP_POST_VARS["tag"]\', \'$HTTP_POST_VARS["typ"]\', \'$HTTP_POST_VARS["datum"]\', \'$ergebnis1\', \'$ergebnis2\')";

but on executing it, i get this error-message:

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /home/sites/site05/web/new_clanwar.php on line 19

i think it has got something to do with the ' ' or \ but i can't figure it out... can someone please help me out?


frag patrick.metz@epost.de

 

[danielhozac]

You could try this

$query = "INSERT INTO clanwar (name, tag, typ, datum, ergebnis1, ergebnis2) VALUES ("'" . $HTTP_POST_VARS["name"] ."', '" . $HTTP_POST_VARS["tag"] . "', '"  . $HTTP_POST_VARS["typ"] . "', '"  . $HTTP_POST_VARS["datum"] . "', '$ergebnis1', '$ergebnis2')";

This really is just a "cleaner" way to do it. //Daniel

 

[frag]

hm... i keep getting paring errors...

the tabel has a date field, is there something special i have to think of if i want to insert a date?
is it '2002-08-27' or what?

this drives me wild...


patrick.metz@epost.de

 

[danielhozac]

Could you post the relevant code? I mean, more than just one line would really make it easier to diagnose what's wrong. //Daniel

 

[sleipnir214]

I infer that your spoken language is German. From that I assume from your variable names that $HTTP_POST_VARS["datum"] contains a date.

Yes, you need to place quotes around a date constant in an SQL statement -- just as you would around a string. ______________________________________________________________________
TANSTAAFL!

 

[KarveR]

$query = "INSERT INTO clanwar (name, tag, typ, datum, ergebnis1, ergebnis2) VALUES ('$_POST[name]', '$_POST[tag]', '$_POST[typ]', '$_POST[datum]', '$ergebnis1', '$ergebnis2')";


______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[frag]

daniel's first post actually was the solution!

besides having messed up wiht all the ', \, and " i referenced a wrong field-name too... *blameonme*

thank you very much guys! you help me out... like always

cu

frag patrick.metz@epost.de